Thread: Sum if X
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed
 
Posts: n/a
Default 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!