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?


message edited by mecerrato

See More: Sumproduct with filtered data

Reply ↓  Report •

Related Solutions

Ask Question