Prev: Industrial Time look up sheet
Next: How to change data from two rows into 2 columns
From: ib1qb on 10 May 2010 18:53
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?


From: Ron Rosenfeld on 10 May 2010 20:05
On Mon, 10 May 2010 15:53:01 -0700, ib1qb <ib1qb(a)discussions.microsoft.com>
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
From: Billy Liddel on 10 May 2010 20:27
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?
>
>
 | 
Pages: 1
Prev: Industrial Time look up sheet
Next: How to change data from two rows into 2 columns