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.

[zbor]

Why can't you use SUMIF again?

[soupra591]

SUMIF doesnot work in this case because of the break between 884 and 124

[zbor]

SUMIF will ignore blanks. Can you upload example excel workbook?
Make sure to avoid all private informations.

[JOHN H. DAVIS]

Would something like this be of use?

Please Login or Register  to view this content.

[soupra591]

Sure, attached is a file that has the example.

SUMIF will ignore blanks. Can you upload example excel workbook?
Make sure to avoid all private informations.

[soupra591]

Sure, attached is a file that has the example.

Attachment 302076

SUMIF will ignore blanks. Can you upload example excel workbook?
Make sure to avoid all private informations.

[soupra591]

Attachment 302078Sure, attached is a file that has the example.

Attachment 302076

SUMIF will ignore blanks. Can you upload example excel workbook?
Make sure to avoid all private informations.

[soupra591]

It needs to be automated, so I can't have any user inputs...this output data will go into a montly workbook after the part number quantity is calculated

Would something like this be of use?

Please Login or Register  to view this content.