I have a column that I average the sum (ignoring blank cells in the formula)
sum of column, divided by count of cells that are not blank.

here is the formula that is in B10...
=(SUM(B4:B9))/COUNTA(B4:B9)

When I insert a row above B10 the formula does not change to incorporate
that additional row. How can I get the formula to recognize new rows?
should now be
=(SUM(B4:B10))/COUNTA(B4:B10)

Thanks
--
deb