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...