Forum Discussion
Formula average
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)... ...
Perhaps
=SUMPRODUCT(B1:D1,B2:D2)
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(?)...