Sumif
 

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.

Sumif
 

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

Sumif
 

Bob,

Works perfectly. thanks

Ron

"Bob Phillips" wrote:

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