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 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 sheetNext: How to change data from two rows into 2 columns