How to use SUMPRODUCT WITH IF CONDITION(S) in EXCEL=SUMPRODUCT(($B$3:$B$12="Nicola"),$D$3:$D$12,$E$3:$E$12)#excel #exceltips #exceltutorial