Hi

Can you please advise the easiest method to achieve the following.

I need a formula to perform a calculation using the last cell in a
range that contains a value. The range would be say A1:A365 and each
day the user will add to the bottom of the range (for each day of the
year) and I need to calculate from this on a rolling basis (basically a
yearly average).

I hope this is easy to understand.

Thanks

VC


--
uplink600
------------------------------------------------------------------------
uplink600's Profile: http://www.excelforum.com/member.php...fo&userid=9408
View this thread: http://www.excelforum.com/showthread...hreadid=520998