Match 2 cells and total another
 

I have a worksheet with 12 columns.
I have
part # in Column F,
Part Description in Column D
Quantity in Column B.
I would like to find all of the part # that match the part description
and total the
quantity. I may have the same parts and description in several rows.
I
would also like to combine the rows so I only have 1 row for each
part
with only the total qty,

B D F
QTY Part Description Part #
6 SHCS 1/4-20 x 4
5 FHCS 1/2-13 x
3.5
4 SHCS 3/8-16 x
2.25
3 SHCS 1/4-20 x 4
6 SHCS 1/4-20 x
2
4 FHCS 1/2-13 x
3.5
2 SHCS 3/8-16 x
2.25
3 SHCS 1/4-20 x 4

The results should be on a seperate sheet like the following
With all of the columns in between.
B D F
QTY Part Description Part #
18 SHCS 1/4-20 x 4
9 FHCS 1/2-13 x
3.5
6 SHCS 3/8-16 x
2.25

Can anyone point me in the right direction to do this?

Thanks
RP

Match 2 cells and total another
 

why not try pivot table option
--
hemu


"rpick60" wrote:

I have a worksheet with 12 columns.
I have
part # in Column F,
Part Description in Column D
Quantity in Column B.
I would like to find all of the part # that match the part description
and total the
quantity. I may have the same parts and description in several rows.
I
would also like to combine the rows so I only have 1 row for each
part
with only the total qty,

B D F
QTY Part Description Part #
6 SHCS 1/4-20 x 4
5 FHCS 1/2-13 x
3.5
4 SHCS 3/8-16 x
2.25
3 SHCS 1/4-20 x 4
6 SHCS 1/4-20 x
2
4 FHCS 1/2-13 x
3.5
2 SHCS 3/8-16 x
2.25
3 SHCS 1/4-20 x 4

The results should be on a seperate sheet like the following
With all of the columns in between.
B D F
QTY Part Description Part #
18 SHCS 1/4-20 x 4
9 FHCS 1/2-13 x
3.5
6 SHCS 3/8-16 x
2.25

Can anyone point me in the right direction to do this?

Thanks
RP

Match 2 cells and total another
 

Try a sumif,
=SUMIF(K2:K9,K12,I2:I9), this is not set up for the columns you want, but
you should be able to adapt it.

David

"rpick60" wrote:

I have a worksheet with 12 columns.
I have
part # in Column F,
Part Description in Column D
Quantity in Column B.
I would like to find all of the part # that match the part description
and total the
quantity. I may have the same parts and description in several rows.
I
would also like to combine the rows so I only have 1 row for each
part
with only the total qty,

B D F
QTY Part Description Part #
6 SHCS 1/4-20 x 4
5 FHCS 1/2-13 x
3.5
4 SHCS 3/8-16 x
2.25
3 SHCS 1/4-20 x 4
6 SHCS 1/4-20 x
2
4 FHCS 1/2-13 x
3.5
2 SHCS 3/8-16 x
2.25
3 SHCS 1/4-20 x 4

The results should be on a seperate sheet like the following
With all of the columns in between.
B D F
QTY Part Description Part #
18 SHCS 1/4-20 x 4
9 FHCS 1/2-13 x
3.5
6 SHCS 3/8-16 x
2.25

Can anyone point me in the right direction to do this?

Thanks
RP