Count Qty in one column if another column ='s

[dilligas2u]

This is what I had in another workbook
[TABLE="width: 781"]
<tbody>[TR]
[TD][/TD]
[TD]Part Number[/TD]
[TD]Description[/TD]
[TD]RV QTY[/TD]
[TD]Heat[/TD]
[TD]Line[/TD]
[TD]Reason[/TD]
[TD]Stamp[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1139395[/TD]
[TD]Housing[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Shrink[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1139395[/TD]
[TD]Housing[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]Slag[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1138395[/TD]
[TD]Cap[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]Dirt[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

and below that
[TABLE="width: 729"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]Pin Holes[/TD]
[TD]Shrink[/TD]
[TD]Slag[/TD]
[TD]Cold Seam[/TD]
[TD]Dirt[/TD]
[TD]Filter[/TD]
[/TR]
[TR]
[TD]1133915[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1133925[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]1134005[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

The RV QTY was just added and now I need this to count the number in that column if Reason column =Shrink,Slag,Ect
This works if I enter each number in a different row
=COUNTIFS(B2:B4907,B4909,G2:G4907,"pin holes") I just need to add the RV QTY to this.
Getting reports in a different format now so had to add RV column
This worksheet is about 5000 rows then the below that part it also goes on to do the top 5 of each reason code
Hope this can be understood