- - Percentage of filled cells
(https://www.excelbanter.com/excel-worksheet-functions/8845-percentage-filled-cells.html)
Carla Bradley
Percentage of filled cells
I have a client with Excel 2002. He wants to calculate a row of data and the
result would be the percentage of fields with a value in them. So for example
if I asked it to check 20 cells and 10 had numbers in them, I'd get a result
of 50%. Anyone know of a way of doing this?
Thanks.
Carla Bradley
Bob Phillips
=COUNTA(A1:A20)/ROWS(A1:A20)
or
=COUNTA(A1:Z1)/COLUMNS(A1:Z1)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Carla Bradley" wrote in message
...
I have a client with Excel 2002. He wants to calculate a row of data and
the
result would be the percentage of fields with a value in them. So for
example
if I asked it to check 20 cells and 10 had numbers in them, I'd get a
result
of 50%. Anyone know of a way of doing this?
