Sumproduct/Match

[JTL9161]

I am having a brain block.

I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order.

I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column A and C.


5 abc 5 cde
4 cde 4 xyz

so for the label CDE it would return a value of 9 or the sum of c1+a2


Thanks
James

 

[Special-K99]

in E1
=SUMIF(D$1:D$1000,B1,C$1:C$1000)+A1
and copy down the column

 

[JTL9161]

Sorry...not working. Here's what I have:=SUMIF(D$1:D$2,B1,C$1:C$2)+A1

and I'm getting 5

[TABLE="width: 523"]
<colgroup><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD]5[/TD]
[TD]abc[/TD]
[TD]5[/TD]
[TD]xyz[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]xyz[/TD]
[TD]5[/TD]
[TD]wxy[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

This is working.
Look at the formula.
D1:D2 is matched against B1
B1 is "abc". There is only one "abc" in your list.

You haven't copied the formula down the column either.
If you copy the formula down the column on the second row you get 9 which is correct.
This relates to the "xyz" code