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