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