Having some issues and would greatly appreciate any guidance.
I have two tabs. Tab2 is a pivot table of summarized data. Tab1 is the worksheet I'm working on. I have been pulling information from Tab2 into Tab1 using vlookups. However, thus far I have only looked for individual variables. Now I would like to sum a range of vlookups from Tab2.
I've attached a sample spreadsheet.
I'm guessing I need to do SUMPRODUCT or SUMIFS, but can't seem to figure out what to do. AddingRangeofVLookups.xlsx
put in Tab1's B2 and drag-fill down:
is that what you mean?
Please Login or Register to view this content.
UPDATE:
Please Login or Register to view this content.
Last edited by icestationzbra; 02-08-2013 at 09:06 PM. Reason: better understanding...
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
No, no, in cell B10, I want it to simply say '30'. Is that possible?
Last edited by jeffreybrown; 02-08-2013 at 08:06 PM. Reason: As per Forum Rule #12, please don't quote whole post unless necessary -- it's just clutter.
Try this :
Formula:
Please Login or Register to view this content.
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thank you. That works, but the range I'm working with is much larger. Is there a way to make a concise formula, something like this that doesn't return an error?
=SUM(VLOOKUP(A2:A6,'Tab2'!$A$3:$C$7,3,FALSE))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks