Count only displayed cells/rows

  • Thread starter Thread starter MDTC
  • Start date Start date
M

MDTC

I have multiple rows of data entered and at any given
time I hide rows to only display the desired data. I
want to then count the remaining number of rows/cells.
Any suggestions on how I do this?
 
Hi MDTC!

You might look at SUBTOTAL. This differentiates between rows that are
hidden manually and those hidden by a filter with filtered rows are
excluded from the SUBTOTAL. Instead of hiding cells manually you can
put a flag entry in a helper column and filter on that column instead
of hiding the rows manually.

Alternatively, put in a flag entry and then count the non-flagged
entries:

=COUNTIF(A1:A100,"<>"&"x")
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks!
-----Original Message-----
Hi MDTC!

You might look at SUBTOTAL. This differentiates between rows that are
hidden manually and those hidden by a filter with filtered rows are
excluded from the SUBTOTAL. Instead of hiding cells manually you can
put a flag entry in a helper column and filter on that column instead
of hiding the rows manually.

Alternatively, put in a flag entry and then count the non-flagged
entries:

=COUNTIF(A1:A100,"<>"&"x")
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Back
Top