Thread: Using Indirect with Named Ranges
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Héctor Miguel Héctor Miguel is offline
external usenet poster
  
Posts: 434
Default Using Indirect with Named Ranges
hi, !

... I'm not clear why that works but it does.

try with: =sum(indirect(cell 1) indirect(cell 2))

it's the sum of the intersection [if any] of both ranges

regards,
hector.


Reply With QuoteReply With Quote