Array Trend in Excel 1

[abitslow]

Hi, I'm trying to use named arrays in Excel with the TREND function. I can do a SUM using named arrays to select data, such as

{=SUM(IF((Array1="yes")*(Array2="Big"),Array3,""))}

Note: {} achieved by Ctrl+Shift+Enter after typing in the formula

I'm failing to do a TREND in the same way, such as

{=TREND(IF((Array1="Yes"),ArrayY,""),IF((Array1="Yes"),ArrayX,""),NewX)}

Can it be done? What am I doing wrong?
Many thanks in advance,
Matt.

 

[SkipVought]

I perfer using SUMPRODUCT...
[tt]
=SUMPRODUCT((Array1="yes")*(Array2="big")*(Array3))

=TREND(SUMPRODUCT((Array1="Yes")*(ArrayY)),SUMPRODUCT((Array1="Yes")*(ArrayX)),NewX)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

oops,

for the TREND...
[tt]
{=TREND(((Array1="Yes")*(ArrayY)),((Array1="Yes")*(ArrayX)),NewX)}
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[abitslow]

Brill! Many thanks Skip! Works wonders for data mining.