There are two named ranges or cells that store the mode values and product list at any point in the worksheet
So that sum would be the sumproduct or sumif of the types selected. If no types selected, it will simply add up all the types.
Fro example if range [mode] has m1 and range [types] has type1, type2,type3 then cell C24 should display 1357. If range [types] is empty, then the sum will return the total for m1 mode = 2244
How do I set up the formula to do this? sampleExample101.xlsx