View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
chris j chris j is offline
external usenet poster
 
Posts: 2
Default using THREED function with VLOOKUP to sum across multiple workshee

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!