Forum Discussion
Running Average
Help! I am creating a budget spreadsheet where I can enter my expenses for each month into a separate worksheet on excel. I would like to keep a running average cost of different expenses. I wa...
It is also possible to create 3D range references of the form
=Sheet1:Sheet4!$B$2
In the following, I have used a defined name 'Values' to refer to the range, allowing
= SUM(Values)
= AVERAGE(Values)
=COUNT(Values)
The number of functions that work with 3D ranges is very limited though, so care is needed before you commit to such a strategy.