Exclude Hidden Row Values

  • Thread starter Thread starter Dewayne
  • Start date Start date
D

Dewayne

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.
 
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.
 
Type 'subtotal' into help. You will need something like this:
=SUBTOTAL(2,A2:A5)
=SUBTOTAL(3,A2:A5)
 
Using Excel 2003. It appears I can make the subtotal work for me. Thank you
for your help!
 
Back
Top