Thread: SUMIF Value error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
margie margie is offline
external usenet poster
  
Posts: 26
Default 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)
Reply With QuoteReply With Quote