| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using THREED function with VLOOKUP to sum across multiple workshee
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 |
| 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) | |||
Threaded Mode
