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
|