Hi,

Try:

=SUMPRODUCT(--(A2:A18=D1),--(A2:A18<=E1),B2:B18)

Where D1 contains 1/1/2009 and E1 contains 1/31/2009

In 2007 you can also use:

=SUMIFS(B2:B18,A2:A18,"="&D1,A2:A18,"<="&E1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"MiJa" wrote:

I have two columns: A is Date (format 1-Jan, 14-Feb, 6-Mar, etc.) and B is
Amount ($). I want to search column A and if it contains Jan, I want to sum
the amounts in Column B. How do I accomplish this?