Issue with an excel formula, please help

[richard1234567891011]

Hi guys I am new. Hello to everybody.
I have a big issue with a formula that I need it for work. The formula that I need it is: IF in a range of cells there is at least one YES put 0 otherwise put -12*$F22. I am becoming mad with this formula. My excel it is also in Italian. Thank you to everyone.

 

[Dryver14]

=IF(COUNTIF(H1:H7,"Yes"),0,-12*F$22)

 

[richard1234567891011]

Yes I tried this formula. But it is not working. (; instead of , because in mac I have to use
In italian is: =SE(CONTA.SE(G111:AO111;"YES");0;-12*$F22)

 

[richard1234567891011]

Yes!!!! it is working now. I don't know why. Thank you very very much!!!!!!!!!!!!!!!

 

[Dryver14]

Not sure what changed but glad to have helped