Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing or avg moving ranges based on week and day???
Hello Friends
I am stumped right now. I have a series of large spreadsheet that I am attempting to automate and here is a stripped doen look at one of them. These sheets feed into a master sheet with all of the totals and summaries that are calculated weekly. Well one of the biggest headaches is at the beginning of the month is the need to adjust the dates and the summary/totals columns. To added insult to injury, my director recently requestd that the if there is a SAT at the beginning of the month I have to add it to the totals for the following week(every SAT). I have automated most of the steps.... however the path that I was going down does not support when there are less than 7 days in the 1st week (which is every month this year except 2, hence my ???). "=IF(ISERR(SUM(D8:D14))=TRUE,"",IF(WEEKDAY(B14)=7, SUM(D8:D14),""))" A B C D E 1 Date Penetration Sales 2 8/1/2006 11% 5052 3 8/2/2006 21% 2869 4 8/3/2006 16% 4006 5 8/4/2006 11% 3015 6 8/5/2006 15% 4515 ??? 7 8/6/2006 21% 4576 8 8/7/2006 17% 4292 9 8/8/2006 13% 4011 10 8/9/2006 5% 2559 11 8/10/2006 4% 3490 12 8/11/2006 13% 3244 13 8/12/2006 11% 3465 25637 14 8/13/2006 6% 3424 15 8/14/2006 7% 3757 16 8/15/2006 3% 3361 17 8/16/2006 5% 2164 18 8/17/2006 6% 3206 19 8/18/2006 5% 2559 20 8/19/2006 4% 3490 21961 Does anyone have any thoughts either with vba or a formula? I would really like something more dynamic so I can use it for other columns throughout this project... Thanks in advance for your help,,, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing By Week | Excel Worksheet Functions | |||
Moving data based on date ranges | Excel Worksheet Functions | |||
Moving week numbers | Excel Worksheet Functions | |||
Summing moving ranges & dates | Excel Worksheet Functions | |||
Summing Number by Week and Month | Excel Programming |