Adding using IF?

[yimkhoc]

A B C D
HOURS BONUS BONUS BONUS
WORKED PAYABLE PAID

172.50 £43.13 YES £43.13
172.50 £43.13 YES £43.13
172.50 £43.13 YES £43.13
172.50 £43.13 YES £43.13
172.50 £43.13 NO £0.00
172.50 £43.13 YES £43.13
172.50 £43.13 YES £43.13
172.50 £43.13 YES £43.13

I have a simple If formula in place in column C that will remove a bonus if
NO is entered. What I want to do is add up the number of NOs in column C to
provide a total at the bottom of the worksheet, so I need to set a value of
YES=0 and NO=1, but I'm not sure how to do this and create a running total...

Can anyone help?

 

[JMay]

use:
=COUNTIF(C1:C10,"No")

 

[yimkhoc]

Thanks - works a treat!!

use:
=COUNTIF(C1:C10,"No")