Count Based on a Single Criteria in a Filtered List
Unfiltered List
Filtered List
The following formula counts the number of times a value in B3:B10 equals the value in D2, in a filtered list...
=SUMPRODUCT(SUBTOTAL(3,OFFSET(B3:B10,ROW(B3:B10)-ROW(B3),0,1)),--(B3:B10=D2))
Based on the sample data, the formula returns 3.
Sample Workbook: Download