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

=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?

Thanks.
Carla Bradley