Joe,

Try it like this. This does Jan 2009

=SUMPRODUCT((A16:A421=DATE(2009,1,1))*(A16:A421<= DATE(2009,1,31))*(I16:I421))

Mike

"Joe Peldoni" wrote:

I'm having trouble figuring how to work with dates in one column as the
criteria to add amounts in another column.

The desired outcome is to add those amounts in column B that occur between
two dates (say, between 2/26/09 and 5/10/09). I've used the following formula
but get #VALUE for an answer:

=SUMPRODUCT(--(A16:A421=1/1/09),--(A16:A421<2/1/09),--(I16:I421))

This is using Excel 2003.