Sum if X

E

Ed

Hello, if I have in cell C a price which is made up of 3 values: D, F, H, but
not in all cases all of these apply. So on cell E, G, and I would like to
have a "x", that if I do have it then it sums the value to the left to the
value to cell C, If i have all 3 with x's, it sums all, and so on... How can
I manage that?

thanks in advance!
 
B

Bill Kuunders

One way,
change the "x" in columns EGand I to a 1
in C1 enter =(D1*E1)+(F1*G1)+(H1*I1)
extend down

use edit find replace to change the x's to 1
 
B

Bob Phillips

=D2*(E2="x")+F2*(G2="x")+H2*(I2="x")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top