| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=counta() unless row is hidden
ok, thanks!
susan On Aug 21, 3:38*pm, Jacob Skaria wrote: Works for 2003 and greater versions -- If this post helps click Yes --------------- Jacob Skaria "Susan" wrote: thanks, jacob, that works great at work on my 2007 excel here at work. *i'll keep it in mind for a good function to use! *got any ideas for <2007 versions? *when i open the old 2000 version it doesn't work, & at home i only have '03. thanks again susan On Aug 21, 2:43 pm, Jacob Skaria wrote: Check out the helo for the below function...The below will return the number of cells with data in Column B which are visible...Please note that hidden cells are hidden through menu... =SUBTOTAL(103,B:B) If this post helps click Yes --------------- Jacob Skaria "Susan" wrote: hi all in column A i have some text data. *some of the rows have been hidden. *i want to count how many are left (visible). *but any COUNT functions count the hidden rows, too. *any ideas? thanks a lot in advance. susan- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
| Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
| Autofilter COUNTA formula not taking into account hidden cells | Excel Discussion (Misc queries) | |||
| How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
Hybrid Mode
