Prev: Hyperlinking images
Next: How can I remove a link that won't go away
From: Chris J Chris on 30 Mar 2010 17:30
Hi,

I am having the same issues as others but haven't been able to resolve them.
The formula I have tried after the add in installation is
=SUMPRODUCT(--(THREED('General Scientific:tab1'!A3)=AE3,(THREED('General
Scientific:tab1'!J3)))). I am looking to sum j3 numbers in the same cell in
every tab if the criteria of ae3 matches that in a3 in every tab. Can you see
what my error could be here? So frustrating.

Thanks!
From: Chris J on 30 Mar 2010 18:31

Sorry if this is a repeat but I can't see if my last one posted. I am trying
to replicate the same thing everyone else is but it's not working. I have the
add in. This is my formula
=SUMPRODUCT(--(THREED('B2B:tab1'!A3)=AE3,(THREED('B2B:tab1'!J3)))). I am
trying to look in all tabs from the A3 cell that is equal to the contents of
AE3 and if it is to sum the range of all amounts in J3 on every tab. What am
I doing wrong? I get N/A as a result. Thanks.
From: NBVC on 31 Mar 2010 09:30

Maybe you forgot a closing bracket on your first argument?

Works for me like this:

=SUMPRODUCT(--(THREED('General
Scientific:tab1'!A3)=AE3),(THREED('General Scientific:tab1'!J3)))


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: 74
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=191796

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Hyperlinking images
Next: How can I remove a link that won't go away