Sum with 2 conditions

[TorrO]

Hi

a b c
1 5 2,5 Yes
2 5 1,5 No
3 6 3,5 Yes
4 5 4 Yes
...
124

I will sum column b if column a = 5 and column c=Yes Result = 6,5 (2,5+4)

I tried this with (control+enter to make matrix)
=IF($A$3:$A$124=5;SUMIF($c$3:$c$124;"Yes";$b$3:$b$124);0)

This did not work.

Please give me a hand

Torro

 

[wideboydixon]

=SUMPRODUCT(($A$3:$A$124=5)*($C$3:$C$124="Yes");$B$3:$B$124)

WBD

 

[FormR]

Or with SUMIFS()

=SUMIFS(B3:B124;A3:A124;5;C3:C124;"yes")

 

[TorrO]

Or with SUMIFS()

=SUMIFS(B3:B124;A3:A124;5;C3:C124;"yes")

Thanks a lot, i did not know this =SumIFS( formula, now i do!