SUMIF
 

=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

SUMIF
 

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




--


Regards,


Peo Sjoblom


"Kevin" wrote in message
...
=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

SUMIF
 

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",S UM(F194:H194),0)

or is there a better way


"Peo Sjoblom" wrote:

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




--


Regards,


Peo Sjoblom


"Kevin" wrote in message
...
=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

SUMIF
 

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?



"Kevin" wrote:

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",S UM(F194:H194),0)

or is there a better way


"Peo Sjoblom" wrote:

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




--


Regards,


Peo Sjoblom


"Kevin" wrote in message
...
=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

SUMIF
 

Change the 0 in the formula to ""
--
David Biddulph

"Kevin" wrote in message
...
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?

"Kevin" wrote:

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",S UM(F194:H194),0)

or is there a better way


"Peo Sjoblom" wrote:

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




--


Regards,


Peo Sjoblom


"Kevin" wrote in message
...
=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