Formula average

Question

Hi,I want to find the average price of a product, but the product has 3 different prices - and I want the average based on which one sells most (if that's possible to understand)...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;Price &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;82 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 54 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 44% of product sale &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 33% &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;53% &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14%&nbsp;Does anyone know a formula i can use? :-) &nbsp;&nbsp;

fresen · Answer

Think I got it right now then, thanks for you help :-)&nbsp;

twifoo · Answer

Which one sells most? Such question presupposes that there are multiple products with varying quantities of sales, which are missing in your given data. Please provide such data so I can decipher the appropriate formula that will deliver the result you expect.
Also, what do you mean with the given percentages? Do they refer to the sales mix of 3 products? Please clarify.

sergeibaklan · Answer

Perhaps

=SUMPRODUCT(B1:D1,B2:D2)

fresen · Answer

1 product3 Prices for the same product (ordinary/student/member)&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ordinary &nbsp; &nbsp; &nbsp; &nbsp;Student &nbsp; &nbsp; &nbsp; &nbsp; MemberPrices &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;82 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 54 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 44% of sale. &nbsp; &nbsp; &nbsp; 33%. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;53%. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14%&nbsp;So it's one product, but with three different prices. I want to find the average outgoing price for that product, when i sell the product for different prices...&nbsp;&nbsp;F.ex.:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Ordinary &nbsp; &nbsp; &nbsp; &nbsp;StudentPrices &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50% of sale &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50% &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 50%&nbsp;This would mean that the average outgoing price for the product - depending on how much the different prices sells - is 75.&nbsp;&nbsp;

fresen · Answer

I got (almost) the same answer, when I used =(B1*B2)+(C1*C2)+(D1*D2). (61,67)

But when I tried to insert the formula you suggested, I get an error code saying there's a problem with the formula(?)...

Forum Discussion

Formula average

7 Replies