Smithgall
Board Regular
- Joined
- May 24, 2006
- Messages
- 68
I run across this type of need occasionally. In this lastest need i am filling in data across collumns. each column is a different day. What I would like to do is on every 7th collumn in (sunday) i want to total some of the data. for example if A1 is where the hours worked is listed i want to go to F2 and put the sum of teh past 7 days. since each collumn has a variety of stats that i add and delete according to what i am tracking (units sold, calls made, hrs worked, etc) I may need to add SUM cells occasionally as i decide different criteria to track.
QUESTION
How do i avoid going through 365 collumns and looking for each 7th column to add my formula. is there a way to do this automatically?
QUESTION
How do i avoid going through 365 collumns and looking for each 7th column to add my formula. is there a way to do this automatically?