VBA Program to sum values in one column if another column holds a particular value...HELP

[soupra591]

I am trying to use the SUMIF statement to add one column if another column has a specific part number...the issue is that I cannot use SUMIF directly as there are random gaps in the columns.

For example:

Column 1:
Quantity
3
6
2

4
2
1

Column 2:
Part Number:
884
124
884

124
884
124



The spreadsheet needs to be able to add the total number of parts produced and output that number in another cell.