Date ranges in a sum formula

M

Marcus Caterino

I need to add a series of deposits received between two dates (6/1706 to
6/23/06) and can't figure out how to make it work.

Help!!

Marcus
 
T

Toppers

E1, E2 are your two dates, A is list of dates and B your deposits

=SUMPRODUCT(--(A1:A20>=E1),--(A1:A20<=E2),B1:B20)

HTH
 
B

Biff

Hi!

Try one of these:

A1:A21 = dates
B1:B21 = deposits

D1 = 6/17/2006
E1 = 6/23/2006

=SUMIF(A1:A21,">="&D1,B1:B21)-SUMIF(A1:A21,">"&E1,B1:B21)

=SUMPRODUCT(--(A1:A21>=D1),--(A1:A21<=E1),B1:B21)

Biff
 
Top