Exclude Hidden Row Values
What version of Excel are you using? If you're using Excel 2003 or later you
can use the SUBTOTAL function with the 100 series arguments.
--
Biff
Microsoft Excel MVP
"Dewayne" wrote in message
...
Is there a way to exclude counting values in a total when rows are hidden
and
including them when they are not hidden in a COUNT, COUNTIF, and COUNTA
formula?
Thank yoiu for any help.
--
Dewayne
|