| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - search key is more than once available
I am trying to total all amounts for 1 specific key in one cell.
Example: search key is "boy" in a table. Since this key is used various in this specific table (not sorted) the outcome of VLOOKUP should total all amounts that match "boy". Currently I only got the first match, but all other "boys" are ignored (not totaled). Does someone have the answer? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP - search key is more than once available
Without an example of your data and what result you expect it is a bit hard
to visualize exactly what you need. However, it appears that you want to sum some data based on criteria so lookup SUMIF and SUMIFS in help. They might do what you want. -- Regards, OssieMac "MCFD" wrote: I am trying to total all amounts for 1 specific key in one cell. Example: search key is "boy" in a table. Since this key is used various in this specific table (not sorted) the outcome of VLOOKUP should total all amounts that match "boy". Currently I only got the first match, but all other "boys" are ignored (not totaled). Does someone have the answer? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP - search key is more than once available
SUMIF works perfect, Thanks!
"OssieMac" wrote: Without an example of your data and what result you expect it is a bit hard to visualize exactly what you need. However, it appears that you want to sum some data based on criteria so lookup SUMIF and SUMIFS in help. They might do what you want. -- Regards, OssieMac "MCFD" wrote: I am trying to total all amounts for 1 specific key in one cell. Example: search key is "boy" in a table. Since this key is used various in this specific table (not sorted) the outcome of VLOOKUP should total all amounts that match "boy". Currently I only got the first match, but all other "boys" are ignored (not totaled). Does someone have the answer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP date search | Excel Worksheet Functions | |||
| VLOOKUP and MATCH w/ name search? | Excel Worksheet Functions | |||
| vlookup with search? | Excel Worksheet Functions | |||
| how do i use vlookup to search for a value on another sheet? | Excel Worksheet Functions | |||
| Can VLOOKUP be used to search for more than one possible value? | Excel Discussion (Misc queries) | |||
Linear Mode
