Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing weekending dates
Hello,
Below is a sheet that shows where I store data. 20's 30's 40's 50's 60's December 01, 2005 December 02, 2005 December 03, 2005 9 2 4 5 December 04, 2005 December 05, 2005 4 5 8 6 December 06, 2005 December 07, 2005 December 08, 2005 December 09, 2005 7 5 9 2 1 On a separate sheet I am trying to figure out a formula that will add seven days of data from a weekending date. For example if week ending is listed in A1 as Dec 9, 2005. How would the formula look if I wanted to count all data from 12/3 €“ 12/9 from any of the columns above (say for example from the 20s column). Also €“ will you include anything that would prevent an error if one of the cells was blank. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing weekending dates
Hi!
Try this: Assume your dates start in A2. 20's is in column B, 30's is in column C, etc. A1 = 12/9/2005 =SUMPRODUCT(--(A2:A13=A1-6),--(A2:A13<=A1),--(B2:B13<"")) Biff "Jim" wrote in message ... Hello, Below is a sheet that shows where I store data. 20's 30's 40's 50's 60's December 01, 2005 December 02, 2005 December 03, 2005 9 2 4 5 December 04, 2005 December 05, 2005 4 5 8 6 December 06, 2005 December 07, 2005 December 08, 2005 December 09, 2005 7 5 9 2 1 On a separate sheet I am trying to figure out a formula that will add seven days of data from a weekending date. For example if week ending is listed in A1 as Dec 9, 2005. How would the formula look if I wanted to count all data from 12/3 - 12/9 from any of the columns above (say for example from the 20's column). Also - will you include anything that would prevent an error if one of the cells was blank. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTables - Group Dates, excluding dates | Excel Discussion (Misc queries) | |||
US dates to UK?? | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Summing moving ranges & dates | Excel Worksheet Functions |