Thank you! Thank you! Thank you! I cannot thank you enough. I have been
trying to figure this out for 4 days, as I didn't know this forum existed.
You made my day:)



"Elkar" wrote:

For this example I'll assume date is in column A and amount is in column B:

If you're just interested in a specific month (january) you could use this:

=SUMPRODUCT(B1:B100,--(MONTH(A1:A100)=1))

Or, if you want to easily be able to change the month being summed, you
could place the number of the month in a seperate cell (we'll say C1 for
example) and use this:

=SUMPRODUCT(B1:B100,--(MONTH(A1:A100)=C1))

HTH,
Elkar

"excel guru i'm not" wrote:

I desperately need help here. I have a spreadsheet that has sales price in
one column and the date in another column. It will only add if the date is
the month only i.e., January vs January 1, 2005. I need it to add by month
based on all days within the month because that column has to have the actual
date not just the month.