Counting only displayed cells in the column
Hi there.
There are, at least, two choices:
=SUBTOTAL(2,A2:A11) count only the cells which are not hidden by means of
filters.
OR
=SUBTOTAL(102,A2:A11) count only cells which are not hidden either manually
or by means of a filter.
Regards,
Otávio
"CEG_Staffer" wrote:
I have a worksheet that I would like to be able to count only the displayed
cells in a column i.e. I do not want to count hidden cells (rows). If all
rows are displayed the total count should equal all rows with contents
(counta function), if not - count only those rows displayed.
|