Count Number of Rows
Hoffma wrote...
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).
|