It’s also very fast.
The inputs for these criteria are the cells H5, H6, and H7.
SUMIFS multiple criteria lookup in table
In some situations, you can use the SUMIFS function to perform multiple-criteria lookups on numeric data. To use SUMIFS like this, the lookup values must be numeric and unique to each set of possible criteria. In the example shown, the formula in H8 is: =SUMIFS(Table1[Price],Table1[Item],H5,Table1[Size],H6,Table1[Color],H7) Where Table1 is an Excel Table as seen in the screenshot.
