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


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=517079

=average(A1:A5)
is all you need
assuming your values are in column A1:A5
when your values change so will your average

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

The "By changing cell" in the Goal Seek dialog must be a cell which contains
a value, so it cannot be the cell with the sum formula (You'd get an error
message to the effect). It'll work if you point it at one of the 5 source
cells containing the numbers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neo1" wrote in message
...

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


--
Neo1
------------------------------------------------------------------------
Neo1's Profile:
http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=517079

Max

Like what was said before to change the average you must change one number
in the average set. Set the Goal Seek to vary one of the members of the
average set to change the average value = the number you want.



"Max" wrote:

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

The "By changing cell" in the Goal Seek dialog must be a cell which contains
a value, so it cannot be the cell with the sum formula (You'd get an error
message to the effect). It'll work if you point it at one of the 5 source
cells containing the numbers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Neo1" wrote in message
...

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


--
Neo1
------------------------------------------------------------------------
Neo1's Profile:
http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=517079

"Engineering Accountant" wrote:
Max ...

Neo1 / John, you mean <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Did you try it??

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.

But once you put a number on B1 where the average is, then the average
gets off unless you click back.....also you get a number and with that
number you just subtract from the numbers in the column A right?

Thanks
From John


--
Neo1
------------------------------------------------------------------------
Neo1's Profile: http://www.excelforum.com/member.php...o&userid=30329
View this thread: http://www.excelforum.com/showthread...hreadid=517079

David,

"Janice Blanks"

is trying to find you....

Bernie


"David J. Braden" wrote in message
...
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.

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.