200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
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.
Use the AVERAGE() function.
use this:
=AVERAGE(B3:M3)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.