Thread: Indirect a range that spans multiple sheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Indirect a range that spans multiple sheets
Why are you trying to use INDIRECT?

--
Biff
Microsoft Excel MVP


"jhgravelle" wrote in message
...
I'm having a problem with indirect.

I'd like to get
=SUM('Section A:Section B'!A1)

As I step through my formula I get to here, and then get #Ref!
=SUM(INDIRECT("'Section A:Section B'!A1"))

Is there any way to do this?


Reply With QuoteReply With Quote