Not sure why you use the terms 'weight' and 'average' so I may have missed
the point
You seem to be talking about a geometric series
a + ar + ar² + ar³ ...... ar^(n-1)
In your case r = 1.1 (a 10% increase each time) and n=9 (you have 10
numbers)
You could look at
http://en.wikipedia.org/wiki/Geometric_series and do some
algebra
But I put 1 in A1
In A1 I use =A1*1.1
This I copied down to A10
In A11 I used =SUM(A1:A10)
Then I used Solver to make A11 equal 200 by changing A1; it gave an answer
of 12.5490789765023
I also used Goal Seek and it gave the same result (of course)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Kevin" wrote in message
...
Assume that 10 numbers = 200
What formula would I use to average (weight) these 10 numbers so that the
2nd number is 10% greater than the 1st, the 3rd number is 10% greater than
the 2nd, the 4th number is 10% greater than the 3rd, etc . . . and the
total
of 10 numbers will equal 200?
I'm sure someone knows the answer!
Thanx in advance
Kevin
--
Kevin