count matching advanced filter results


Posted by Charles Moore on April 02, 2001 1:22 PM

I would like to take this one step further by counting
filtered results that match a certain criteria.

e.g. the list has already been filtered by customer
complaint. Rather than re-filter the list by year, I
want to count the number of post-filtered results for
certain years.
"SUBTOTAL(2,ref)" only counts the total number of
complaints, not those that match a certain year.

Thanks,
Charles Moore



Posted by Mark W. on April 02, 2001 2:12 PM

Charles, if you don't want to use AutoFilters maybe
it's time to use an Advanced AutoFilter with a
well-crafted Criteria.