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