adjusting for quantity

[Excel_noob_]

I have a table that lists part numbers in column c, and the quantity of that part number in column b. I would like a way, preferably with a pivot table, to know the total of Part A, and account for the quantity listed in column b. In other words, I don't want to know how many times Part A is listed, I want to know the total number of Part A's that I have in my list.

Col B Col C
QTY: Part#
15 Part A
30 Part A
-------------------
=there are 45 of part A, not 2 in your table.

How do I arrange my pivot table so it gives me the right count? I keep getting a count of 2...

[FDibbins]

Hi and welcome to the forum

2 ways...
click on the table and select sum instead of count

skip the PT and use a sumif()

[Excel_noob_]

how do I use the sumif() function? I'm not familiar with that one.

[RobertMika]

=SUMIF(C2:C9,"part A",B2:B9)