Read your original post. Read what I responded with, carefully following
directions, especially as regards cell locations. If that doesn't do it,
then I suggest you repost your original problem, being very careful to
state what you want, with a *short* example of how your data are
arranged, for example:
"my data are in cells A1 through A5, and their average is calculated in
cell B1 with "=AVERAGE($A$1:$A$5)". I want to adjust the original data
to get the average, calculated in cell B1, to reach a target value I put
into cell C1. What do I do?"

DaveB

David J. Braden wrote:
In line with the other responses, use algebra. If your data are in
cells A1:A5, and the "target average" is in cell B1, then in cell C1
enter =COUNT(A1:A5)*(B1-AVERAGE(A1:A5))
to get a number by which you must adjust cells. You can add/subtract it
from one of your cells, or spread out the "correction".

DaveB

Neo1 wrote:
Hello just a problem I have which I cant seem to get right...

I have the following numbers:

5
6
9
24
56
=Sum of all those numbers above

=Average of the 5 numbers above

Can I actually use goal seek so that I can change my average to another
number by changing say the sum total?

Thanks for your time
From John




--
Please keep response(s) solely within this thread.