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.