Percentage of filled cells

C

Carla Bradley

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
carla.bradley@[DELETETHIS].lgeenergy.com
 
B

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)
 
Top