Exclude Hidden Row Values
 

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

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

Exclude Hidden Row Values
 

Type 'subtotal' into help. You will need something like this:
=SUBTOTAL(2,A2:A5)
=SUBTOTAL(3,A2:A5)

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Dewayne" wrote:

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

Exclude Hidden Row Values
 

Using Excel 2003. It appears I can make the subtotal work for me. Thank you
for your help!
--
Dewayne


"T. Valko" wrote:

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


.

Exclude Hidden Row Values
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Dewayne" wrote in message
...
Using Excel 2003. It appears I can make the subtotal work for me. Thank
you
for your help!
--
Dewayne


"T. Valko" wrote:

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


.