D
Don
You need to create a price cell for each unit where you
input the price/unit, then call that cell into your
formulas as needed. Assume your price/apple is in
M1, "John" is in Row 2, and "Apples Quanity" is in Col B
formula for apples for John would be something like:
=(B2*M1)
Adjust formulas for other buyers and expand for other
products using the same format.
Col B, C,.....etc. could then be Sum'd giving you total
number of each product and total cost of each product.
input the price/unit, then call that cell into your
formulas as needed. Assume your price/apple is in
M1, "John" is in Row 2, and "Apples Quanity" is in Col B
formula for apples for John would be something like:
=(B2*M1)
Adjust formulas for other buyers and expand for other
products using the same format.
Col B, C,.....etc. could then be Sum'd giving you total
number of each product and total cost of each product.