[Solved] SUMIF based on dates (month)

Excel 2007 - pretty basic question but just can't seem to find the right answer.

Column A = Dates (10/01/10, 10/05/10, 06/15/10, 02/26/07)etc.)
Column B = Values

I'm trying to SUM column B based on all values in a given month.

Thanks

One way is to use SUMIFS functuion in Excel 2007. Put the 1st of the month to sum in C1 and use

=SUMIFS(B:B,A:A,">="&C1,A:A,"<="&EOMONTH(C1,0))

Originally Posted by Russell719

Tried that got the , "You've entered too few arguments..."

Are you sure you used SUMIFS? Because if you use SUMIF you will get a "too many arguments" error.