dilligas2u
New Member
- Joined
- Mar 5, 2018
- Messages
- 7
This is what I had in another workbook
<tbody>
</tbody>
and below that
<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
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