| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autosum results of multiple if statements?
I used multiple IF statements to return a number from 0 to 8. I now need to
sum the results of the returned numbers in a row. When I use =Sum(A7:J7) it returns 0. How do I get a total on this Row? Copy of statement =IF(B3=$B$2+1,"1",IF(B3=$B$2,"2",IF(B3=$B$2-1,"4",IF(B3=$B$2-2,"8","0")))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup formulas to obtain multiple results | Excel Worksheet Functions | |||
| if statements depending on multiple VLOOKUP functions | Excel Discussion (Misc queries) | |||
| Add multiple vlookup results | Excel Worksheet Functions | |||
| combining IF and AND statements for multiple columns | Excel Discussion (Misc queries) | |||
| multiple nested IF statements | Excel Worksheet Functions | |||
Threaded Mode
