| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula returns error in version 2003 only
I cannot figure out why this formula works in version 2002 SP1 but I get
"#value" when I try to use it in version 2003 Professional: =SUMPRODUCT(--(AU8:AU55-DAY(AU8:AU55)+1=AZ57),AX8:AX55) Can any one suggest how to resolve this problem? ie what's causing it?A -- D. W. Cameron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with formula that unexpectedly returns an answer | Excel Worksheet Functions | |||
| sumif formula returns incorrect value | Excel Worksheet Functions | |||
| excell 2003 will not open previous version | Excel Discussion (Misc queries) | |||
| Excel 2003 - cells in formula? | Excel Discussion (Misc queries) | |||
| Microsoft XP and 2003 version | Excel Discussion (Misc queries) | |||
Linear Mode
