Sumif using the =month() - doesn't work

[69gto]

I am probably making a very simple mistake here but I can't seem to find it. Thanks in advance to those that reply.

I need to add a dollar amount in column B (B16:B21) when the date in column A is in a certain month (3 or March). Here is what I have tried:

=SUMIF(A16:A21,((MONTH(A16:A21)="3")),B16:B21)

I have tried :

=SUMIF(A16:A21,">02/31/05",B16:B21) - SUMIF(A16:A21,">=03/31/05",B16:B21)

Simple example: Answer should be 50 (adding the two number in march's date)

January 10, 2005 ----100
January 21, 2005 ----100
February 3, 2005 ----50
February 9, 2005 ----50
March 10, 2005 ----25
March 10, 2005 ----25

[swatsp0p]

This may not be the best solution, but it will get you what you ask...

I'm not sure MONTH will work with a range... however, you can insert a helper column to list the value of MONTH() and use that in your formula, as such:

Insert a new column B and enter =MONTH(A16) and copy down through B21. Then use this formula:

=SUMIF(B16:B21,"=3",C16:C21)

The return is 50.

HTH

Bruce