Making a formula continuous
 

I have the formula =SUM(K$5:K10)/5. I need the next cell down to have
the formula =SUM(K$5:K11)/6 and then the next down =SUM(K$5:K12)/7 and
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
------------------------------------------------------------------------
Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696
View this thread: http://www.excelforum.com/showthread...hreadid=474141

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


--
Neil_Pattison
------------------------------------------------------------------------
Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696
View this thread: http://www.excelforum.com/showthread...hreadid=474141

Hi!

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

Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile: http://www.excelforum.com/member.php...fo&userid=4785
View this thread: http://www.excelforum.com/showthread...hreadid=474141

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

"Neil_Pattison" wrote:


I have the formula =SUM(K$5:K10)/5. I need the next cell down to have
the formula =SUM(K$5:K11)/6 and then the next down =SUM(K$5:K12)/7 and
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
------------------------------------------------------------------------
Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696
View this thread: http://www.excelforum.com/showthread...hreadid=474141

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

"Neil_Pattison" wrote:


I have the formula =SUM(K$5:K10)/5. I need the next cell down to have
the formula =SUM(K$5:K11)/6 and then the next down =SUM(K$5:K12)/7 and
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
------------------------------------------------------------------------
Neil_Pattison's Profile: http://www.excelforum.com/member.php...o&userid=27696
View this thread: http://www.excelforum.com/showthread...hreadid=474141