Count Qty in one column if another column ='s

[dilligas2u]

This is what I had in another workbook

	Part Number	Description	RV QTY	Heat	Line	Reason	Stamp
	1139395	Housing	3			Shrink
	1139395	Housing	2			Slag
	1138395	Cap	4			Dirt

<tbody>
</tbody>

and below that

Part Number	Pin Holes	Shrink	Slag	Cold Seam	Dirt	Filter
1133915	0	0	0	0	0	0
1133925	0	0	0	0	0	0
1134005	0	0	0	0	0	0

<tbody>
</tbody>

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