Making a formula continuous

  • Thread starter Thread starter Neil_Pattison
  • Start date Start date
N

Neil_Pattison

I have the formula =SUM(K$5:K10)/5. I need the next cell down to hav
the formula =SUM(K$5:K11)/6 and then the next down =SUM(K$5:K12)/7 an
so on.

The problem I have is getting the last number to add by 1 each time
without typing it in by hand.

Does anyone know how to do this. Any help would be greatly appreciated
 
Hi!

You could use the fact that ROW() reads the number of the row in whic
the formula appears.

Al
 
Hi,

From your formulas, it looks like the denominator is one less than the
number of values added. So the following formula should work,

=SUM(K$5:K10)/(COUNT(K$5:K10-1)

Regards,
B. R. Ramachandran
 
Hi,

There was a typo in the formula in my earlier reply. It should be,
=SUM(K$5:K10)/(COUNT(K$5:K10)-1)

Regards,
B. R. Ramachandan
 
Back
Top