Making a formula continuous

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
 
A

AlfD

Hi!

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

Al
 
B

B. R.Ramachandran

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
 
B

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
 
Top