Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if X
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if X
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 -- Greetings from New Zealand Bill K "Ed" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if X
=D2*(E2="x")+F2*(G2="x")+H2*(I2="x")
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ed" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|