Hi,

Thanks, I will try it this weekend after the holiday is over.

JK

"tjtjjtjt" wrote in message
...
You might try this instead. I tested my first formula this morning and got
an
incorect result.
=SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),B1:B100)

tj

"Jerry Kinder" wrote:

Hi,

Col A has dates in order
Col B has amounts

Cell D1 is the beginning date
Cell E1 is the end date

I want to sum Col B where the dates in ColA are between the dates in D1
and
E1.

Thanks for your help.

Jerry