I want to look up a primary machine number in a table.
If the primary machine number is a match, I want to look at the grade number.
If the grade number is also match, I then want to look at the customer number.
If the customer number also matches, I want to sum all tons where the primary, machine, grade number, and customer number match.
There can be multiple matches: i.e., multiple line items with matching primary machine, customer number, and grade number.
What is the proper formula to use?
-- corrupted images removed --
If the primary machine number is a match, I want to look at the grade number.
If the grade number is also match, I then want to look at the customer number.
If the customer number also matches, I want to sum all tons where the primary, machine, grade number, and customer number match.
There can be multiple matches: i.e., multiple line items with matching primary machine, customer number, and grade number.
What is the proper formula to use?
-- corrupted images removed --
Last edited by a moderator:
