Forum Discussion
Formula for sum of multi-dropdown with two variables
Here is the table set up: Column A Column B Column C Column D Column E Column F Date Person Details Amount Category Split 12.1.22 One Notes 12.00 Food 1 12.2.22 One, ...
=SUMPRODUCT(ISNUMBER(SEARCH(RIGHT($A$9,3),$B$3:$B$5))*($E$3:$E$5=A10)*$D$3:$D$5)You can try this formula.