Thread: INDIRECT with Sheet Level Defined Name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NickH NickH is offline
external usenet poster
  
Posts: 60
Default INDIRECT with Sheet Level Defined Name
Whoops! I meant I've tried this...

{=SUM(INDIRECT("'" & F2 & "'!Length_List")*INDIRECT("'" & F2 & "'!
Used_List"))}
Reply With QuoteReply With Quote