One way:
=SUMPRODUCT(--(MONTH(A1:A365)=2),B1:B365)
Hope this helps
Rowan
"ZMAN" wrote:
> Hi, I have a spreadsheet that has every day of the year (1/1/2004 to
> 12/31/2004) and I am trying to sum a column next to it to get only
> totals for each month. Basically I want to know what I get as a sum
> for all of January, February, etc.
>
> So I am trying to use SUMIF in combination with Month(A1:A365)=1
> through =12 and just sum those that are in month 1 and then those in
> month 2, etc.
>
> Column A has all dates and column B has revenue numbers ($ made that
> day)
>
> Can anyone suggest how to do it right?
>
> I was trying arrays like:
> for February: {=SUM(IF((MONTH(A:A)=2),1,0)*(B:B))}
>
> I also tried SUMIF such as:
> example February: =SUMIF(A:A,MONTH(A:A)&">"&"2",B:B)
>
> I know I am doing something utterly wrong but can you please help?
>
> Thanks!
>
>
Bookmarks