BETWEEN DATES SUM

[Jerry Kinder]

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

 

[tjtjjtjt]

I believe this should do it:

=SUMIF(A:A,">="&D1,B:B) - SUMIF(A:A,">"&E1,B:B)

tl

 

[tjtjjtjt]

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]

Hi,

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

JK

 

[PiRaTe_ PiRaTe via OfficeKB.com]

=SUMIF(A1:A9,"<="&DATE(2004,4,2),B1:B9)-SUMIF(A1:A9,"<"&DATE(2004,3,29),B1:B9)

Try something like the above.

A1:A9 would reference your dates to be summed.

B1:B9 references the column to be summed due to the specified date range.

Of course you would need to set your range in the identical format.

Hope this helps you out