|
|
| 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 C3:C10 equals
the value in E2, in a filtered list...
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C3:C10,ROW(C3:C10)-ROW(C3),0,1)),--(C3:C10=E2))
Based on the sample data, the formula returns 3. Sample
Workbook |
|
|
