| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding using IF?
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding | Excel Discussion (Misc queries) | |||
| Just adding | Excel Discussion (Misc queries) | |||
| Help with adding 10% | Excel Worksheet Functions | |||
| Adding an OR to SUM(IF.... | Excel Worksheet Functions | |||
| Adding * to the end | Excel Discussion (Misc queries) | |||
Threaded Mode
