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