Making a formula continuous

[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

 

[Neil_Pattison]

This is sorted now, it was the AVERAGE function I was afte

 

[AlfD]

Hi!

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

Al

 

[Guest]

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

 

[Guest]

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