Match 2 Columns and Add the Values of Third Column

N

njsidd

Hello,

By matching two column I want to add the third column, but only the desire
model

Column 1= Model
Column 2= Size
Column 3= Qty

Column 1
JE-122
JE-123
JE-124
JE-125
JE-122

Column 2
50
80
100
150
50

Column 3
2
2
3
4
1


After Matching Column 1 and Column 2 the result should be as follows:

For Model JE-122 and size 50 Total Qty=3

and vise versa..



Can some one help me in this regard???
 

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

Top