ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Match 2 cells and total another (https://www.excelbanter.com/excel-programming/406248-match-2-cells-total-another.html)

rpick60

Match 2 cells and total another
 
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


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com