| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
adding values lists
I found the article "How to look up a value in a list and return multiple
corresponding values" ( http://office.microsoft.com/en-us/ex...260381033.aspx ) very helpful but I need to go one step further. I would like one cell to be able to look up a value in one list and return the corresponding value in another list. If the look up value occurs multiple times, I need the values in the other list to be added up. The summed value is what I need the cell to return to me. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
adding values lists
The below formula would sum entries in column B if the corresponding cells in
Column A = "Y" =sumif(A:A,"Y",b:b) If this post helps click Yes --------------- Jacob Skaria "CalvinFenny" wrote: I found the article "How to look up a value in a list and return multiple corresponding values" ( http://office.microsoft.com/en-us/ex...260381033.aspx ) very helpful but I need to go one step further. I would like one cell to be able to look up a value in one list and return the corresponding value in another list. If the look up value occurs multiple times, I need the values in the other list to be added up. The summed value is what I need the cell to return to me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding to drop down lists | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Adding entry to validation list without retyping all lists | Excel Discussion (Misc queries) | |||
Linear Mode
