View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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