| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting rows in a spreadsheet, but I don't want to count hidden r
I am trying to count rows in a spreadsheet that there are hidden rows.
Everything I try always counts the hidden rows. Anyone? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting rows in a spreadsheet, but I don't want to count hidden r
Excel 2003 and later
=SUBTOTAL(103,A2:A40) will only count visible rows in A2:A40 assuming they are not empty If you have an earlier version you would need VBA -- Regards, Peo Sjoblom "petprincess" wrote in message ... I am trying to count rows in a spreadsheet that there are hidden rows. Everything I try always counts the hidden rows. Anyone? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Emailing Spreadsheet with Hidden Rows | Excel Discussion (Misc queries) | |||
| Protecting only Hidden Rows on a Spreadsheet | Excel Worksheet Functions | |||
| Counting Hidden Rows | Excel Discussion (Misc queries) | |||
| Counting non-blank cells in a column, excluding hidden rows | Excel Worksheet Functions | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
Linear Mode
