SUMIF

[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

 

[Peo Sjoblom]

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




--


Regards,


Peo Sjoblom

 

[Guest]

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

 

[Guest]

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?

 

[David Biddulph]

Change the 0 in the formula to ""