Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula that has to do with dates.
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need a formula that has to do with dates.
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 --------------- Jacob Skaria "Excel4dummies" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula using dates | Excel Worksheet Functions | |||
Dates formula | Excel Worksheet Functions | |||
formula for dates | Excel Worksheet Functions | |||
Need a Formula for DATES | Excel Worksheet Functions | |||
how do I use if formula using dates? | Excel Worksheet Functions |