how to count unhided rows

M

mangesh

hi
i have an excel sheet wherein i have put name of my client from cell A
To A1000, some rows from A1 To A1000 has been hided. Now I would lik
to know the procedure how to count the number of my client that has no
been hided
 
F

Frank Kabel

Hi
how have you hidden your rows?. If you have used a Filter ('Data -
Filter') use SUBTOTAL. e.g.
=SUBTOTAL(3,A1:A1000)

if you have hidden these rows manually AND you have Excel 2003 use
=SUBTOTAL(103,A1:A1000)

If you have hidden the rows manually and have a version prior Excel
2003 you'll need VBA to count the rows
 

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

Similar Threads

Excel Need Countifs Formula Help 0
Counting texts 2
Unhide a row 1
Delete Timestamp 2
Cannot unhide the hidden rows in my spreadsheet 3
hide, unhide column or row after protect worksheet 4
Copy/Paste array formulae from the newsgroup 6
counting every 3 rd row 4

Top