Date ranges in a sum formula
 

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

Date ranges in a sum formula
 

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

"Marcus Caterino" wrote:

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

Date ranges in a sum formula
 

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

"Marcus Caterino" <Marcus wrote in
message ...
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