Goal Seel To get Average!?

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

=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" <[email protected]> wrote in message
news:[email protected]...
>
> 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" <[email protected]> wrote in message
> news:[email protected]...
> >
> > 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
> >
>
>
>

Did you try it??

"Engineering Accountant" wrote:
> Max ...

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

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

David,

"Janice Blanks" [email protected]

is trying to find you....

Bernie


"David J. Braden" <[email protected]> wrote in message
news:[email protected]...
> 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.