# need a formula that has to do with dates.

E

#### Excel4dummies

Date Hand-Carry Mail One Day Mail
October 1, 2009 10 15 5
October 2, 2009 10 15 5
October 3, 2009 10 15 5
October 4, 2009 9 5 7
October 5, 2009 15 9 6
October 6, 2009 12 13 6
October 7, 2009 6 5 6
October 8, 2009 11 13 6
October 9, 2009 11 13 6
October 10, 2009 11 13 6
October 11, 2009 11 13 6
October 12, 2009 11 13 6
October 13, 2009 11 13 6
October 14, 2009 11 13 6
October 15, 2009 11 13 6
October 16, 2009 11 13 6
October 17, 2009 11 13 6
October 18, 2009 11 13 6
October 19, 2009 11 13 6
October 20, 2009 11 13 6
October 21, 2009 11 13 6
October 22, 2009 11 13 6
October 23, 2009 11 13 6
October 24, 2009 11 13 6
October 25, 2009 11 13 6
October 26, 2009 11 13 6
October 27, 2009 11 13 6
October 28, 2009 11 13 6
October 29, 2009 11 13 6
October 30, 2009 11 13 6
October 31, 2009 11 13 6
Date Hand-Carry Mail One Day Mail
October 7, 2009 6 5 6

Date Hand-Carry Mail One Day Mail
October 8, 2009 11 13 6

Total = 17 18 12
Date Range Total =

Want to get the total between Oct 7, and Oct 11. Where it says "Date Range
Total". I know the wording is a bit sloppy. I want to get the total of
Hand-Carries and "Mail One Day" through out (again) Oct 7 and Oct 11.

Thank you.

J

#### Jacob Skaria

With from and to dates in E1 and E2 try

=SUMPRODUCT(--(A2:A100>=E1),--(A2:A100<=E2),B2:B100+C2:C100)

If this post helps click Yes