| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using THREED function with VLOOKUP to sum across multiple workshee
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I would like to set a footer that is the same on multiple workshee | Excel Discussion (Misc queries) | |||
| How do I link a print header to variable data in multiple workshee | Excel Worksheet Functions | |||
| Can we use multiple if with VLookup function | Excel Worksheet Functions | |||
| Multiple If and Vlookup function | Excel Worksheet Functions | |||
| Why are there multiple instances of same person on shared workshee | Excel Discussion (Misc queries) | |||
Hybrid Mode
