Named Ranges in Array Formulas

[jfitzpat]

Can I use Named Ranges in Array Formulas?

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

I get the following error:
Value not available error

 

[T. Valko]

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.

 

[jfitzpat]

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