I want to know what percentage HAVE a (numeric) value.

Assume the range is A1:A10.

=COUNT(A1:A10)/ROWS(A1:A10)

Format as Percentage

--
Biff
Microsoft Excel MVP


"JLeck" wrote in message
...
I have a column of numbers, and I want to calculate how many rows have a
non-blank in them. Regardless of the value in the cells, I want to know
what
percentage HAVE a (numeric) value. How do I do that? Thanks.