"weighted" average function ?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Weighted Average Calc for duplicated values only 0
weighted average profit margin 4
weighted average from table 3
weighted average - 1 column 2
Calculating weighted average of Percent Change 0
Volume Weighted Average 3
How to omit blank cells when calculating weighted averages 20
Weighted average question 7

Top