Sumproduct with filtered data

October 14, 2016 at 13:42:39
Specs: Windows 7
I am using the formula below to sum a range based on criteria. the problem is that it does not work if the data is filtered or only gives me a partial sum if some of the data is filtered out. How can I modify the formula to give me the total count even if part of the data in the range is filtered out insofar as the criteria is met?

=SUMPRODUCT(SUBTOTAL(3,OFFSET(F7:F20736,ROW(F7:F20736)-MIN(ROW(F7:F20736)),,1)),--(K7:K20736="Y"),F7:F20736)

message edited by mecerrato


See More: Sumproduct with filtered data

Reply ↓  Report •

Related Solutions


Ask Question