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

1. ## 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

2. ## Re: Divide a Cell by the number of populated cells in a column

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

3. ## Re: Divide a Cell by the number of populated cells in a column

Perfect

Thank you

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1