formula help

  • Thread starter Thread starter chad
  • Start date Start date
C

chad

i have a worksheet that i use to figure my operators 5
day sales average. the question that i have is i my
formula to automatical move over one column when i add a
new column for example:

A B C D E F
1 monday tuesday wednesday thursday friday AVG
2 1sale 1sale 3sales 2sales 1sale .42
3 4hours 4hours 4hours 3hours 4hours
4
5
....

So say i want to add a new column in between e and f how
woul i make my calculation move over from A2-E2 To A3-
(F3) with out having to redo the calculations on a daily
basis.

thanks
chad

p.s. i hopw you can make sence of this. if not let me
know and i might be able to make it a little more clear.
 
do you mean B2 to F2 rather than A3 to F3. Do you want to maintain a 5 day
average or are you increasing the number of days averaged? Why would adding
a column move down one row?
 
Back
Top