R
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.
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.