Match 2 cells and total another

R

rpick60

I have a worksheet with 12 columns. I have part # in Column F, Part
Description in Column D and 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
 

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

Match 2 cells and total another 2
Consolidation Table from Different Excel Tabs with Different Format 1
find cells that match in column 1
Document Merge Formatting Issue 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
Modify working code to expand the output. 5

Top