Thread: Named Ranges in Array Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jfitzpat jfitzpat is offline
external usenet poster
  
Posts: 8
Default Named Ranges in Array Formulas
Can I use Named Ranges in Array Formulas?

Example here :
{=SUM(IF((ResourceName=$A28)*(ProjectID=$C28),OTLH ours))}

I get the following error:
Value not available error
Reply With QuoteReply With Quote