| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding result of "if" statement..
I have created this "if" statement.
=IF(G17=(166719),"1", IF(G17=(165852),"2", IF(G17=(165851),"0", IF(G17=(166718),"1", IF(G17=(166685),"4", IF(G17=(166745),"0", IF(G17=(""),"" ))))))) Now i want to add the result of this statement from consecutive rows. i did sum on the results but i am not able to add the results of my statements. can you tell me how i can add the results of this statement? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a row immediately following a "true" statement | Excel Discussion (Misc queries) | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| Adding values generated by "IF" Statement | Excel Discussion (Misc queries) | |||
| Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
| Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
Threaded Mode
