ExcelBanter - Count

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count (https://www.excelbanter.com/excel-worksheet-functions/104881-count.html)

KeyMike

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

Allllen

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

Bob Phillips

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

All times are GMT +1. The time now is 12:44 PM.