Hi everyone,

I am trying to use the SUMPRODUCT formula to calculate some fields in my worksheet, but whenever I filter the information, the formula does not adjust to reflect the visible rows/columns. When I use the SUBTOTAL formula, the formula does adjust when filtering and only calculates visible rows. I have tried to manipulate the SUBTOTAL formula to result in the same mathematical answers, but I am having no luck. Is there a way to have the SUMPRODUCT formula calculate only visible entries? Or another formula I can use/manipulate to yield the same result?

I would really appreciate any help!!

Thanks

Matt