| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Value error
getting #Value error in cell if source file isn't open when using SUMIF
formula. Once file is opened the correct $$/amounts appear and there are no errors. why am i getting value errors using this formula??? see example of formula i am questioning below. =SUMIF('R:\Signature\ATB\atb seq 23 Jun07.xls'!TB,Payors!C17,'R:\Signature\ATB\atb seq 23 Jun07.xls'!TBTL)+SUMIF('R:\Signature\ATB\atb seq 23 Jun07.xls'!TB,Payors!C23,'R:\Signature\ATB\atb seq 23 Jun07.xls'!TBTL) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error with SUMIF but not SUM(IF) | Excel Worksheet Functions | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
| If and nested Sumif error | Excel Worksheet Functions | |||
| countif / sumif function error | Excel Worksheet Functions | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
Threaded Mode
