Hi All,
I am trying to solve a puzzle ONLY through VLOOKup or LOOKUP function, whereby I want to add all the multiple rows ( of the column NETSALES ) where the result is matched. Example: I want to calculate the total NETSALES where the number of customers are 8 & 9. Key workbook enclosed. Thanks.
SAHDEV.
Try
=SUMIF(C4:C16,6,D4:D16)
for the sum of individuals with 8 & 9 customers...
=SUMPRODUCT(SUMIF(C4:C16,{8,9},D4:D16))
Note: Not sure a VLOOKUP is right for this situation...
Last edited by jeffreybrown; 03-11-2013 at 10:28 PM.
HTH
Regards, Jeff
Maybe if you explained why it needs to be VLOOKUP or LOOKUP, we could come up with a solution to meet your needs, otherwise, we look for the best solution we can come up with for the actual problem
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
Hi, thanks for the replies.
I recently appeared for an online exam where it was specifically mentioned to solve this query ONLY using LOOKup / VLOOKUP function. I tried hard but failed, so thought to check for the solution.
Any further help would be a great learning for me. Thanks.
That's a strange question, there are so many ways to get it without a 'lookup' of any kind..
as a matter of fact, without getting absolutely absurd, I can not come up with a decent 'lookup' formula to do it...everything I start to get near right numbers for is so long it's not even worth posting....
Maybe someone else has ideas for it
As far as I know even the Lookup or Vlookup (with Array Notion) requires a sum function before it so that it can get the total of the matches.
I don't think so that the Lookup Or Vlookup in single cell formula without helper column/cell(s) can able do it
If anyone come up with a solution which makes the above one as false statement then I am glad to see the approach
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I agree, I would love to see a (concise) 'V/lookup' solution, because I know it is beyond me
In H16 This formula can be used to get sum using Vlookup. But a helper column "F" is used.
Pl see the attached file.
Please Login or Register to view this content.
Marvelleous !
This what I am looking for. It works great. Thanks kvsrinivasamurthy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks