To count only records that match a filter criteria, you use the SUBTOTAL function.

Name: To count only records that match a filter criteria, you use the SUBTOTAL function.
Brand: Quizplus
Rating: 4.8 (38 reviews)

Question

Quizplus · Accepted Answer

The SUBTOTAL function can be used to count only the records that match a filter criteria. The function can be used with various functions like COUNT, AVERAGE, MAX, MIN, etc. The function includes or excludes hidden rows based on a specified filter, and can be used to perform calculations on only the visible cells in a range.

To Count Only Records That Match a Filter Criteria, You