Forum Discussion
Solved
SUMPRODUCT Function with Criteria for Visible Rows
I am trying to get the totals for a column in a table based on a condition. In my example, I want to filter by a column (Fans) and then get the count for when the value for the column (Change) is a ...
Here you go:
=SUMPRODUCT((Table1[Change]<0)*SUBTOTAL(102,OFFSET(E4,ROW(Table1[Change])-MIN(ROW(Table1[Change])),0)))
Here you go:
=SUMPRODUCT((Table1[Change]<0)*SUBTOTAL(102,OFFSET(E4,ROW(Table1[Change])-MIN(ROW(Table1[Change])),0)))
Awesome formula and solution. Thanks!