J
Jim
Hi,
I have a simple spreadsheet with column B containing all dates, and column D
containing all numerical values. The dates range throughout a year. At the
bottom of the sheet I've entered January through December in another column.
To the immediate right of the month named, I have a formula which gives me
the total for that month. For instance, next to January my formula reads:
=sumproduct(--(month(b6:b370)=1),d6:d370) this formula works, but it seems
to me I should be able to use SUMIF too. I've tried
=sumif(d6:d370,month(b6:b370)=1,d6:d370) but that just returns a blank cell.
I know this is silly, but it's driving me nuts. Can someone explain what I'm
missing?
TIA,
Jim
I have a simple spreadsheet with column B containing all dates, and column D
containing all numerical values. The dates range throughout a year. At the
bottom of the sheet I've entered January through December in another column.
To the immediate right of the month named, I have a formula which gives me
the total for that month. For instance, next to January my formula reads:
=sumproduct(--(month(b6:b370)=1),d6:d370) this formula works, but it seems
to me I should be able to use SUMIF too. I've tried
=sumif(d6:d370,month(b6:b370)=1,d6:d370) but that just returns a blank cell.
I know this is silly, but it's driving me nuts. Can someone explain what I'm
missing?
TIA,
Jim