Hi there, hopefully someone can help. I'm not knowledgeable to a deep level on excel but know what i need to achieve.
Say i have a data validation drop down list of fruits in cells A2-A8 and then the weights (manually entered) of those fruits next to them in B2-B8. Then the quantity of fruits which weight the same in C2-C8. Some fruits may appear more than once in the A2-A8 list because their weight is unique.
I would like to sum all oranges, for example, which weigh less than X and then multiply them by a unit price and quantity, then sum all oranges which weigh more than X and multiply them by a price and quantity and have the final price return in a cell. There are a max of 4 different price tiers which are weight dependant.
Many thanks in advance,
All the best.
Ben
Say i have a data validation drop down list of fruits in cells A2-A8 and then the weights (manually entered) of those fruits next to them in B2-B8. Then the quantity of fruits which weight the same in C2-C8. Some fruits may appear more than once in the A2-A8 list because their weight is unique.
I would like to sum all oranges, for example, which weigh less than X and then multiply them by a unit price and quantity, then sum all oranges which weigh more than X and multiply them by a price and quantity and have the final price return in a cell. There are a max of 4 different price tiers which are weight dependant.
Many thanks in advance,
All the best.
Ben