SUMIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=SUMIF(B194,"DHC2",F194:I194)

I am using this to add F194, G194, H194, and I194 if B194 = DHC2 the problem
is it is only adding F194, not the other three.

I am using Office 2007
 
Thanks Peo,

If I wanted it to add the same cells if B194 was to = DHC3 as well as DHC2
would I enter it like this

=IF(B194="DHC2",SUM(F194:H194),0)+IF(B194="DHC3",SUM(F194:H194),0)

or is there a better way
 
The formula you gave me =IF(B194="DHC2",SUM(F194:H194),0) works, but if B194
does not = DHC2 it enters 0 in the cell. How do I get rid of that and have
nothing in the cell?
 
Back
Top