|
That should be pretty easy - you just need to make sure the range of your two formulas includes all of the cells where you MIGHT eventually have data. Sum and average formulas ignore blank cells, so that won't hurt anything. So if you're putting your values in column B, your running total formula would be something like:
=SUM(B1:B500) or even just =SUM(B:B)
And your average formula would be:
=AVERAGE(B1:B500) or even just =AVERAGE(B:B)
|