Count repeating values and the total used

[Tcurtis]

I have a spread sheet that has some repeating values and a total number of used for each value. I am trying to get a sum of each value in a pivot table but because there may be more than one used, this value is incorrect. Below is a short example:
Parts Description Quantity Used
1234 Hammer 1
1234 Hammer 1
1234 Hammer 2
1345 Driver 3
1345 Driver 1
1234 Hammer 2
1426 Mallet 1
The Hammer total is actually 6 but in a pivot table it is only counting the amount of parts with the number 1234 so the result is 4. I have a large file so it is a lot to go through and try to correct. How can I get a correct count of items that were used?

Thanks

 

[ChrisM]

Use text-to-columns to turn "1234 Hammer 1" in to three columns: "1234" "Hammer" and "1". Then use your pivot table again, but ignore the "1234" column.

 

[Tcurtis]

I should have explained that better, my fault. I have three columns, A is Parts, B is Description and C is Quantity. The pivot table counts all of the like items in column A-Parts but the total used is more that what it is counting. How can I get it to count the correct quantity used?

 

[ChrisM]

Are you sure the pivot field for quantity is set to "SUM OF" instead of "COUNT OF"?

 

[Tcurtis]

Wow, I brought over and was counting the sum of the column A not the sum of the quantity column. I put the quantity column in values and it is fixed. Thanks!