=AVERAGE(A1:A50000)
can you just insert an average Function in there; where the range is where the data you want averaged begins, then just make it go to like 10,000 to end? that way as you add stuff, whatever you've added each day etc, is captured by that range?
__________________
Life is 99% inspiration, 1% Perspiration, and 1% Attention to Detial.
RIP & Godspeed:
Saccoppo
Lonewolf Ed
Fire Me Boy
|