How to count and sum the values

[Akustatics12420]

Can someone help me please. Why it didnt change? 
When i change value "C10" to 1. Its work but when i put the formula =IF(......). The sum didnt workout

[#2]

Hello

Remove the "" around 1.

[#3]

Thank you! :D work like a charm