Create SumIf function for date parameters

M

Miroshak

Can someone help me in creating a sumif function that will add all the dollar
amounts corresponding to only January's dates. I've tried to use the formula
below with no success.

Date Dollar
January 1, 2007 40 =SUMIF(A2:A10,"">=(MONTH(1)),Dollar)
January 5, 2007 55
January 9, 2007 56
February 2, 2007 40
February 4, 2007 12
February 14, 2007 78
March 1, 2007 62
March 15, 2007 35
March 6, 2007 45
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Macro for pulling information into one sheet 0
Record Click on Error Indicator 2
Calculating monthly start date with a start date 3
Distribution in time 4
Excel PRICE function: How does it compute Issue Date of the Security 5
For Loop 9
Monthly year to date average 3
Transpose Macro 0

Top