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

Ask Your Question

Weekly Poll

Do you think Amazon can re-invent the convenience store?

Discuss in The Lounge

Poll History