Apr 11 2019 12:20 PM
I'm really rusty on this after some years away from Excel.
On attached sheet for example, Jan-Mar is complete, and able to average at bottom.
Once I insert total for April and each month going forward, how do I get that average cell at bottom to auto recalc the new average using correct number of months? Hopefully something automatic, but simple? I don't know the exact terminology for this calculation type. Thanks!
Apr 11 2019 12:50 PM
Hi @msnormand,
Replace the formula in cell B16 with this one:
=B15/COUNTA(B3:B14)
By using the COUNTA function, you can now calculate only the average for months filled with values.
Hope that helps