Quote Originally Posted by Ron Coderre
Hi, Brian

Try this....

For dates in A1:A20 and Amounts in B1:B20

C1: =SUMPRODUCT((TEXT(A1:A20,"MMM-YY")="Jan-06")*B1:B20)

That formula returns the sum of the Col_B values where the Col_A date is in the month of January 2006.

Does that help?

Regards,
Ron
Thanks Ron! This will help in another area of my spreadsheet as well!