If you mean the Average return then with your data in A1:B4 then
=AVERAGE(B1:B3)
*Provided* the individual averages are of the same proportion. ie 5/10,
5/100, 5/1000 is 50%, 5%, 0.5% with an *average* of 18.5% but there are 15
*Returns* out of 1110 items which is really a percentage of 1.35%
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Lightjag" wrote in message
...
I want to calculate the annual return:
Year Return
2004 16.7%
2005 3.2%
2006 13.6%
Annual Return 11.0% <== what formula / array should I use to calc?