The ranges for each argument need to be the same size. For which range
does the first condition need to be met?

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
MattEd101 wrote:

Dominic

I am having reall issues with Threed.

Im trying to incorporate it into a sumproduct as shown in your last
response. The formula is

=SUMPRODUCT(--(THREED(Start:End!A3)=A6),--(THREED(Start:End!A6:A9)=$B6),THREED
(Start:End!C6:D9))

However the first two Threed arrays look at text rather than figures. For
example Start:end!A3 looks at two worksheets with the words Exeter in
worksheet 1 and Barnsley in worksheet 2. However within the formula above the
threed function returns

{0;"Exe ";"Barn ";0}

which when I put in the condition =A6 of "Exeter", the formula returns False.

Is this a limitation of Threed or am I doing something wrong?

Cheers

Matt