Help with changing monthly average

Copper Contributor

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!

1 Reply

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