Sums in my list

  • Thread starter Thread starter I Am
  • Start date Start date
I

I Am

I have 2 lists in a worksheet.
The first list contains 3 columns, and the second list is a single column.
Like this:

Date Part# Qty Part#


The second list is a unique filtered list of the first Part# column. What I
need to do is get the SUM of the Qty field for the part #'s in the first
list, and place it beside the unique Part no. list.

I'm looking around for the solution, but so far all I have found is how to
count unique part numbers in my lists. Not quite the sum I'm looking
for....

Thanks
JB
 
JB

Assuming your first list is in A1:C100, with the headings in row 1 and the
data starting in row 2

and that your list of unique part numbers is in Column F and the first part
# is in F2

Put this formula in F2 and copy down.

SUMIF(B$2:B$100,F2,C$2:C$100)

PC
 
Back
Top