How do I set up a weighted formula in Excel?
 

Can someone help me please? I need to do a weighted formula in Excel 2007,
where the total of the numbers equals 90% of one number and 10% of another
number. Is it possible to do this?

How do I set up a weighted formula in Excel?
 

On Mon, 10 May 2010 15:53:01 -0700, ib1qb
wrote:

Can someone help me please? I need to do a weighted formula in Excel 2007,
where the total of the numbers equals 90% of one number and 10% of another
number. Is it possible to do this?


=sumproduct(numbers, weights)

e.g.

=sumproduct(a1:a2,{0.9,0.1})

--ron

How do I set up a weighted formula in Excel?
 

Sa g1 to j7 contains:

Units Qty Cost Sales
Item 1 90 10 900
Item 2 10 20 200
Totals 100 1100
Wgt Cost1 11
Wgt Cost2 11

The formula in I6 is =(0.9*I2)+(0.1*I3) [q1 * p1]+ [q2 * p2]

We can use this because you already told us that the qtys were in the
proportion 90% and 10%

If you had not given us this information we would have to use this formula
in I7

=(H2*I2+H3*I3)/(H2+H3)

(p*q+p1*q1)/(q+q1)

HTH
Peter
"ib1qb" wrote:

Can someone help me please? I need to do a weighted formula in Excel 2007,
where the total of the numbers equals 90% of one number and 10% of another
number. Is it possible to do this?