How do I count the number of rows with data if I have other rows that are hidden? For example, I have spreadsheet with 30,000 rows (20,000 that are visible and 10,000 that are hidden). I want a function that tell me the number or rows that are not hidden (return a value of 20,000).

Thank you in advance for any comments.