Adding using IF?

  • Thread starter Thread starter yimkhoc
  • Start date Start date
Y

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?
 
Back
Top