how to do avg formula


Attached is my file. I would like to do a formula for the average column which auto calculate monthly without me having to change the formula monthly.

Example: when I have already entered the feb expenses and the avg, is total/2, but come Mar expenses, there is a need for me to change : total/3.  Is there a better formula that I need not attend to edit for the average column.



Selected Answer

Use the AVERAGE() function.

use this:


Put it into cell O3 and then copy the formula down to the rest of the cells.

This will update to give you the latest average at all times.


Answer the Question

You must create an account to use the forum. Create an Account or Login