| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Argument results do not equal cell results Excel
I am using a consitional sum with three variables =SUM(IF('Current Period
NSA'!$D$8:$D$3000=A23,IF('Current Period NSA'!$E$8:$E$3000=B23,IF('Current Period NSA'!$H$8:$H$3000=C23,'Current Period NSA'!$AB$8:$AB$3000,0),0),0)) The argument itself shows the correct answer when I edit the formula but when I close the argument window the cell shows a value of 0. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
| Want to make conditional sounds based on cell values in Excel | New Users to Excel | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
