How do i average 12 cells to the left in a set average formula

A

AverageTone

I'm trying to create a formula which averages the 12 (months) cells on the
left.
Trying to average the sum of a rolling year, e.g Mar>Feb06
Currently using =Sum(Average(R6:AD6)) but everytime i inter a month, i have
to edit and copy down the formula, which is proving a pain.

Thanks for any help recieved.
 
B

Ben Walters

AverageTone
At the moment your post sounds more like an Excel question than an InfoPath
question. If you were doing this in InfoPath then I would create some managed
code to handle the Average calculation that used the current month as a
starting period and calcuated the average from there on.

Hope this helps
Cheers
Ben
 
Top