Avrage of averages

  • Thread starter Thread starter JB
  • Start date Start date
J

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
 
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.
 
Back
Top