Avrage of averages

[JB]

I have, with your help, a column : =IF(E4="","",E4/18) which gives the
average of data in one row.

What I need now is a constantly updated average of all the averages. Should
I do that in a new column? and how? or at the bottom of the column, which
will need it to float downwards, as more rows are added?

Thank yo

 

[Roger Govier]

Hi

In your case as you are only dividing a single cell value by a constant of
18, and Average of the Averages will return the correct result.

So, assuming you have your formula in column F, in cell F3 enter
=AVERAGE(F4:F1000)

Amend the range to suit the amount of data you have. Average will ignore
empty cells.