|
|
| Sum
based on a Single Criteria in a Filtered List |
Unfiltered List
Filtered List
The following formula returns the sum of D3:D10, where the
corresponding value in C3:C10 equals the value in F2, in a
filtered list...
=SUMPRODUCT(--(C3:C10=F2),SUBTOTAL(9,OFFSET(D3:D10,ROW(D3:D10)-ROW(D3),0,1)))
Based on the sample data, the formula returns 180. Sample
Workbook |
|
|
