I'm trying to create a worksheet that will search the bill of materials list for a number of different parts that share common materials and return the sum of their usage in the adjacent cell.
Worksheet 1
Widget 1
Material Type: Qty:
Material A 2
Material B 1
Widget 2
Material Type: Qty:
Material A 1
Material B 2
I wish to query all of worksheet 1 for "Material A", and sum all return values one cell to the right. In the above example, this would equal 3.
Thanks.
Bookmarks