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

=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" <CarlaBradley@discussions.microsoft.com> wrote in message
news:60597924-3CF6-4DBD-93EB-C2749D2ECD3D@microsoft.com...
> 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