Hello,
I'm having trouble making a correct formula to sum up some values in Table1 based on multiple criteria and only in visible rows.
The formula serves as a verification for some data I am reporting and, of course, I need to be sure it is correct.
I tried various formulas by using SUMPRODUCT, SUBTOTAL, AGGREGATE, but nothing worked.
See the attached file with my table of data (Table1), Nm that must be excluded from the sum (H2:H6), desired results obtained with SUMIFS (G2:G3), main slicer (Mt), helper slicer (Nm) and not working formula (D1).
Hopefully someone can help me find a formula that would work.
Bookmarks