Thread: Two same lookup values not adding

Hi all,

I think this is the last issue that will make this formula perfect for what I need. When the SAME lookup value appears more than once, it does not add up all of the values in the array range. For example:

A2 = Red

F5 = Red, Q5 = 2
F6 = Blue, Q6 = 4
F7 = Yellow, Q7 = 3
F8 = Red, Q8 = 5

The formula only recognizes the Red in F5 and gives me a value of 2. What I need for it to do is add up both Q5 and Q8 because Red shows up in F5 and F8, to give me a total sum of 7. Thoughts?? Here's the formula:

=IFERROR(INDEX($Q$5:$Q$13,(MATCH(A2,$F$5:$F$13,0))),0)

I'm so close! Thanks in advance!
JB

Thanks for that. Do you have any suggestions where to incorporate that in the existing formula I have?