View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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).