Calculate new price with conditions

[matt4003]

I found that this function works, but it has the potential to be ver
long.

=sum(if(A2="x",B2*B1,0)+if(A3="x",B3*B1,0)+if(A4="x",B4*B1,0)+if(A5="x",B5*B1,0)+B1)

It would be nice if I could set a range, for exampl
=sum(if(A2:A5="x",((B2:B5)*(B1)+B1),B1))

But I don't think that will work, maybe a sumproduct statement...an
ideas??

Thanks,
Mat

 

[Myrna Larson]

SUMIF will do nicely. You don't need SUMPRODUCT or an array formula. See my
previous response.