PierremontQuaker03
New Member
Hi I need some help in filling this spreadsheet in without doing it manually. All the info is coming from the Raw Data tab.
Taking the first section in the data tab (levant classic) I am wanting a formula for the sun of quantity (column F) and the sum of value column G).
So the formula would need to look at the column D for the customer number, look at the product number (for Levant classic it is “1100”) and then populate the total quantity and sales coming from the raw data tab.
Any help would be great thank you.
Taking the first section in the data tab (levant classic) I am wanting a formula for the sun of quantity (column F) and the sum of value column G).
So the formula would need to look at the column D for the customer number, look at the product number (for Levant classic it is “1100”) and then populate the total quantity and sales coming from the raw data tab.
Any help would be great thank you.