counting rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I suspect this is relatively easy but I'm not sure how to accomplish this. Is there a way to count the "non blank rows" in a specific column. We need to know the number of rows that have been filled in within each column....thanks
 
You can use the Counta function.

=COUNTA(A1:A1000)

This counts any cells within the range that have data in
them.

Hope this helps

Judith
-----Original Message-----
I suspect this is relatively easy but I'm not sure how
Click to expand...
to accomplish this. Is there a way to count the "non
blank rows" in a specific column. We need to know the
number of rows that have been filled in within each
column....thanks
 
Back
Top