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

"Domenic" wrote:

Try...

=SUMPRODUCT(--(THREED(EUR:VGS!$B$12:$B$120)=B13),THREED(EUR:VGS! $G$12:$G$
120))

Hope this helps!

In article ,
CM wrote:

I have downloaded this function, but cannot seem to make it work. I need to
sum up 13 sheets using a vlookup reference (cell B13). This is what I used:

=SUM(VLOOKUP(B13,THREED(EUR:VGS!$B$12:$V$120),6,0) )

EUR:VGS are the sheet names. Each sheet in between has a different name. Is
my naming convention not going to work? Right now it only returns the value
from the first sheet (EUR) only.

Thanks
CM