Hi Biff,

The data is in the row and if there is a zero, i would want to include it in
the calculation

thanks Harry

"Biff" wrote in message
...
Hi!

So, what you want to do is average the last 8 entries, correct?

Is the data in a column or a row?

Are there any empty cells within the range?

Biff

"Big H" wrote in message
...
Hi There,

I have a spreadsheet that each week i have to average the last 8 week
inputs, as you can image each week the last 8 weeks information changes.
Any help would be appreciated.

thanks Big H