Great! That looks good. What if I make it more complicated? Let's say I have
250 rows, but only the first 100 are populated. I want the formula to look at
only those rows that have been populated so far (but I want to keep my blank
rows to allow for growth). So I want to say something like:

What percentage of rows with a non-blank column A have a non-blank column B?

Can I do that?

"daddylonglegs" wrote:

For range A1:A100 try

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

"JLeck" wrote:

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.