| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
Is there some way to use the COUNT or COUNTIF function to count only rows
that are not hidden so that I can use the functions with the autofilter? Thanks in advance for your help. -- Michael Gudyka St. Charles, IL |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count
Try this
http://www.contextures.com/xlFunctions04.html#Visible -- Allllen "KeyMike" wrote: Is there some way to use the COUNT or COUNTIF function to count only rows that are not hidden so that I can use the functions with the autofilter? Thanks in advance for your help. -- Michael Gudyka St. Charles, IL |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count
Look at the SUBTOTAL function in help.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "KeyMike" wrote in message ... Is there some way to use the COUNT or COUNTIF function to count only rows that are not hidden so that I can use the functions with the autofilter? Thanks in advance for your help. -- Michael Gudyka St. Charles, IL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals by count | Excel Discussion (Misc queries) | |||
| Count consecutive dates only | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Linear Mode
