Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-lookup and summing values if more than 1 matches criteria
I am trying to investigate a way in which I can get V-Lookup to sum the
values and bring back the total figure when more than one cell matches the search criteria. E.g. if I am getting it to search for number 46 and I want it to bring back the next column, and there are two 46 matches, and each of the columns I want to bring back having a number in there, I want it to sum the two numbers and bring back the total figure. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-lookup and summing values if more than 1 matches criteria
one way looking for 46 in col E and numbers in columns H:I
=SUM(INDIRECT("H"&MATCH(46,E:E)&":I"&MATCH(46,E:E) )) -- Don Guillett SalesAid Software "holcay" wrote in message ... I am trying to investigate a way in which I can get V-Lookup to sum the values and bring back the total figure when more than one cell matches the search criteria. E.g. if I am getting it to search for number 46 and I want it to bring back the next column, and there are two 46 matches, and each of the columns I want to bring back having a number in there, I want it to sum the two numbers and bring back the total figure. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-lookup and summing values if more than 1 matches criteria
Try the SUMIF function rather than vlookup; the format is roughly:
=sumif(Range to search, What to search for, Range to add upon matching). In your case something like =sumif(B:B,46,C:C). "holcay" wrote: I am trying to investigate a way in which I can get V-Lookup to sum the values and bring back the total figure when more than one cell matches the search criteria. E.g. if I am getting it to search for number 46 and I want it to bring back the next column, and there are two 46 matches, and each of the columns I want to bring back having a number in there, I want it to sum the two numbers and bring back the total figure. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V-lookup and summing values if more than 1 matches criteria
Take a look at =sumif() in excel's help:
=sumif(sheet2!A:A,A1,sheet2!B:B) holcay wrote: I am trying to investigate a way in which I can get V-Lookup to sum the values and bring back the total figure when more than one cell matches the search criteria. E.g. if I am getting it to search for number 46 and I want it to bring back the next column, and there are two 46 matches, and each of the columns I want to bring back having a number in there, I want it to sum the two numbers and bring back the total figure. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to lookup multiple values and summing them up in one cell | Excel Worksheet Functions | |||
Lookup or Summing problem | Excel Worksheet Functions | |||
Lookup value throughout an array_return adjacent value and summing | Excel Worksheet Functions |