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, ...
SUMIFS with wildcard:
=SUMIFS($D$2:$D$4,$B$2:$B$4,"*One*",$E$2:$E$4,I2)SUMIFS if you have the 'person' in a cell to refer to:
=SUMIFS($D$2:$D$4,$B$2:$B$4,"*"&$I$1&"*",$E$2:$E$4,I2)