Count Number of Rows

H

Hoffma

I filtered non-numerical data in a spreadsheet and need to count the number
of remaining rows. The row numbers are not in order due to filtering. What
is an easy way to count the number of rows remaining? COUNTA doesn't work.
 
H

Harlan Grove

Hoffma said:
I filtered non-numerical data in a spreadsheet and need to count the number
of remaining rows.  The row numbers are not in order due to filtering.  What
is an easy way to count the number of rows remaining?  COUNTA doesn't work.  

Pick a column that always has something in it, and use =SUBTOTAL
(3,your_column_ref_here).
 
C

CLR

Assuming you already know the total number of Rows, the SUBTOTAL formula will
give you a COUNTA of just the VISIBLE (ie filtered) cells. Then you can just
subtract the filtered number from the total.

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top