Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | November 2, 2024
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 C4:C12 equals the value in E3 in a filtered list...
=ROWS(FILTER(C4:C12,(C4:C12=E3)*(MAP(C4:C12,LAMBDA(cell,SUBTOTAL(3,cell))))))
For earlier versions of Excel...
=SUMPRODUCT(--(C4:C12=E3),SUBTOTAL(3,OFFSET(C4:C12,ROW(C4:C12)-ROW(C4),0,1)))
Based on the sample filtered data, the formula returns 3.
Sample Workbook: Download