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.

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.