Forum Discussion

msnormand's avatar
msnormand
Copper Contributor
Apr 11, 2019

Help with changing monthly average

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!

excel

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 11, 2019

    Hi msnormand,

     

    Replace the formula in cell B16 with this one:

    =B15/COUNTA(B3:B14)

     

    By using the https://support.office.com/en-us/article/counta-function-7dc98875-d5c1-46f1-9a82-53f3219e2509 function, you can now calculate only the average for months filled with values.

     

    Hope that helps

     

Resources