Sumif

[ronnomad]

I have a data range A-H with an expanding number of rows. Column A contains
dates. Column H contains totals of the input in columns B-G. I want the
totals for each month and am trying the formula
=SUMIF($A$2:$H$30,(MONTH($A$2:$A$30)=4),$H$2:$H$30) but get 0 as the result.
Excel says the criteria is True and there are figures in column H. Why does
this not work and is there an alternative?

Thanks,

Ron R.

 

[Bob Phillips]

=SUMPRODUCT(--(MONTH($A$2:$A$30)=4),$H$2:$H$30)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[ronnomad]

Bob,

Works perfectly. thanks

Ron

=SUMPRODUCT(--(MONTH($A$2:$A$30)=4),$H$2:$H$30)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)