"weighted" average function ?

C

carl

I am trying to determine the 'weighted' average profit for my trades.


My data looks as so...

Contracts Profit

5 .01
5 .04
2 .03


Is there a function in excel that will show me the average profit I make ?

Thank you in advance.
 
D

duane

sumproduct(a1:a3,b1:b3)/sum(a1:a3) would give weighted average of 3 row
of data weighted by column
 
Top