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

Can I use Named Ranges in Array Formulas?

Yes

I get the following error:
Value not available error

Make sure *all* of the arrays are the same size.

--
Biff
Microsoft Excel MVP


"jfitzpat" wrote in message
...
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

I withdraw the question - it does work and I must have had something else wrong

"jfitzpat" wrote:

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