adding values lists

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.
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to look up a value in a list and return multiple corresponding values 7
Pulling multiple values from a list based on a wildcard search value? 4
summating vlookup or index formulas 5
How to do a Vlookup and choose the corresponding Value with highes 3
Looking up a value in a list & returning multiple corresponding va 1
how to lookup a value and return multiple corresponding values 1
Returning multiple instances of the same lookup value 0
Formula (or code) return the largest number of duplicates in a list. 16

Top