ExcelBanter - Using Count Function on Filtered List

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

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

- - Using Count Function on Filtered List (https://www.excelbanter.com/excel-discussion-misc-queries/136527-using-count-function-filtered-list.html)

NJFergs

Using Count Function on Filtered List

How do I get the COUNT function to work on a list that has been filtered.
(i.e. I want the count of the filtered list, not the total list.
--
NJFergs

Gary''s Student

Using Count Function on Filtered List

The SUBTOTAL() function can do that. See Excel Help
--
Gary''s Student
gsnu200712

All times are GMT +1. The time now is 08:12 PM.