| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#value! message in Sumif Formula
I am trying to link to another excel file using a sumif formula and get a
#value! if both files are not open. I have tried the Control Shift Enter and changing the formula but am still not getting it. The formula is =SUMIF([ACPS.xls]Monthly!$D$1:$R$1000,$D6,[ACPS.xls]Monthly!K:K). Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I have error message when formula is over value? | Excel Worksheet Functions | |||
| Error message #NAME from formula | Excel Discussion (Misc queries) | |||
| Error message #NAME from formula | Excel Worksheet Functions | |||
| Formula Error Message | Excel Discussion (Misc queries) | |||
| How do I hide a formula message? | Excel Worksheet Functions | |||
Threaded Mode
