Excel 2007 : How to best use SUMIF

[rtruesdale]

I'm trying to calculate a sum total of dollars spent during a specific month. I have two columns. The first is a date column (eg. 7/5/2011) and the second column is a dollar value. I'm trying to sum the amount of money earned during the month of July, 2011. The date column has dates throughout the year across years.

I'm trying to use the SUMIF formula but can't figure out how to qualify the month and year. Hoping my calculation can look like this:

Month/Year Total
Jan, 11 $5,234.00
Feb, 11 $10,278.00
.
.
.

Please advise
Rick T

[JBeaucaire]

Since you're specifically asking about using SUMIF(), you would need two SUMIF() formulas to get a specific date range.

Column A - Dates
Column B - Values

D1 = 1/1/2011 (formatted as Jan, 2011 if you wish, but the date must be the first of the month)
E1 = 2/1/2011
etc...

In D2, this formula would work:

=SUMIF(A:A, ">=" & D1) - SUMIF(A:A, ">=" & E1)

Then copy that cell across.

[rtruesdale]

Thanks I'll try this. I am open to a better function if you have something simpler to use. Thoughts?

[JBeaucaire]

If this works, then it's good. SUMIF() has the benefit of letting you reference an entire column with no reductions in performance.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.