adding values lists

  • Thread starter Thread starter CalvinFenny
  • Start date Start date
C

CalvinFenny

I found the article "How to look up a value in a list and return multiple
corresponding values" (
http://office.microsoft.com/en-us/excel/HA012260381033.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.
 
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
 
Back
Top