Count only displayed cells/rows

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?
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
G

Guest

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.
Click to expand...
 
Top