| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
valid formula doesn't work in 2003 version
=SUMPRODUCT(--(AU8:AU55-DAY(AU8:AU55)+1=AZ57),AX8:AX55) This formula works
well in my version (2002 SP1) but when I try to use my workbook at the office, (version 2003) the formula gives me #value as a result. I've tried to format my dates differently but no luck. Can anyone help me resolve this problem? Thanks -- D. W. Cameron |
|
#2
|
|||
|
|||
|
valid formula doesn't work in 2003 version
Try this, copy an empty cell, select all number involved in the formula,
then do editpaste special and select add -- Regards, Peo Sjoblom (No private emails please) "Wayne Cameron" wrote in message ... =SUMPRODUCT(--(AU8:AU55-DAY(AU8:AU55)+1=AZ57),AX8:AX55) This formula works well in my version (2002 SP1) but when I try to use my workbook at the office, (version 2003) the formula gives me #value as a result. I've tried to format my dates differently but no luck. Can anyone help me resolve this problem? Thanks -- D. W. Cameron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| My formula does not work! | Excel Worksheet Functions | |||
| 4 Day Work Week in a formula | Excel Discussion (Misc queries) | |||
| Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
| can a workbook with macros created in excel 2003 work in excel 20. | Excel Discussion (Misc queries) | |||
Linear Mode
