ExcelBanter - Named Ranges in Array Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Named Ranges in Array Formulas (https://www.excelbanter.com/excel-worksheet-functions/188252-named-ranges-array-formulas.html)

jfitzpat

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

T. Valko

Named Ranges in Array Formulas

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

jfitzpat

Named Ranges in Array Formulas

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

All times are GMT +1. The time now is 02:48 PM.