Divide a Cell by the number of populated cells in a column

Hi

I have attached a sheet as an example, as i am trying to Divide a cell by the number of populated cells in that column e.g column (A) has a table of 16 but only has 13 populated cells in that column, the sum would be something like this =sum(A18/13. Sometimes the column will have less and at times more populated.

Hopefully its clear to you

Thanks

You can do this in B23:

=B21/COUNTA(B2:B17)

But if you change B19 to this:

=AVERAGE(B2:B17)

it will give you the same result, as AVERAGE ignores empty cells.

Hope this helps.

Pete

Perfect

Thank you