What I am trying to do is find all cells in a range that matches a certain cell then sum all values in the column to the right of the matched cell.
For Example:
In the attached spreadsheet I want to search cells A2:K144 to Find Item#HDPP346-7 and sum all Quantities for cells that match Item Number HDPP346-7.
Does anyone have any suggestions?
Bookmarks