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
Bookmarks