ExcelBanter - using COUNTA on a field that has been filtered

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - using COUNTA on a field that has been filtered (https://www.excelbanter.com/excel-discussion-misc-queries/21726-using-counta-field-has-been-filtered.html)

[email protected]

using COUNTA on a field that has been filtered

HELP
What is the function to count entries on a column that
has been filtered. COUNTA will still count the hidden
fields, rather than just the shown fields

John Wilson

Take a look at the SUBTOTAL function in help.

=SUBTOTAL(3,"your range"))

John

" wrote in
message ...
HELP
What is the function to count entries on a column that
has been filtered. COUNTA will still count the hidden
fields, rather than just the shown fields

All times are GMT +1. The time now is 09:26 PM.