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