Thread: SUMIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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