software

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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: 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 averagegt; Can I actually use goal seek so that I can change
gt; my average to another number
gt; by changing say the sum total?

The quot;By changing cellquot; 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
savefile.com/projects/236895
xdemechanik
---
quot;Neo1quot; gt; wrote in message
...
gt;
gt; Hello just a problem I have which I cant seem to get right...
gt;
gt; I have the following numbers:
gt;
gt; 5
gt; 6
gt; 9
gt; 24
gt; 56
gt; =Sum of all those numbers above
gt;
gt; =Average of the 5 numbers above
gt;
gt; Can I actually use goal seek so that I can change my average to another
gt; number by changing say the sum total?
gt;
gt; Thanks for your time
gt; From John
gt;
gt;
gt; --
gt; Neo1
gt; ------------------------------------------------------------------------
gt; Neo1's Profile:
www.excelforum.com/member.php...oamp;userid=30329
gt; View this thread: www.excelforum.com/showthread...hreadid=517079
gt;
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.
quot;Maxquot; wrote:

gt; gt; Can I actually use goal seek so that I can change
gt; gt; my average to another number
gt; gt; by changing say the sum total?
gt;
gt; The quot;By changing cellquot; in the Goal Seek dialog must be a cell which contains
gt; a value, so it cannot be the cell with the sum formula (You'd get an error
gt; message to the effect). It'll work if you point it at one of the 5 source
gt; cells containing the numbers.
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Neo1quot; gt; wrote in message
gt; ...
gt; gt;
gt; gt; Hello just a problem I have which I cant seem to get right...
gt; gt;
gt; gt; I have the following numbers:
gt; gt;
gt; gt; 5
gt; gt; 6
gt; gt; 9
gt; gt; 24
gt; gt; 56
gt; gt; =Sum of all those numbers above
gt; gt;
gt; gt; =Average of the 5 numbers above
gt; gt;
gt; gt; Can I actually use goal seek so that I can change my average to another
gt; gt; number by changing say the sum total?
gt; gt;
gt; gt; Thanks for your time
gt; gt; From John
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Neo1
gt; gt; ------------------------------------------------------------------------
gt; gt; Neo1's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30329
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=517079
gt; gt;
gt;
gt;
gt;

Did you try it??quot;Engineering Accountantquot; wrote:
gt; Max ...

Neo1 / John, you mean lt;ggt;
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
In line with the other responses, use algebra. If your data are in
cells A1:A5, and the quot;target averagequot; 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 quot;correctionquot;.

DaveB

Neo1 wrote:
gt; Hello just a problem I have which I cant seem to get right...
gt;
gt; I have the following numbers:
gt;
gt; 5
gt; 6
gt; 9
gt; 24
gt; 56
gt; =Sum of all those numbers above
gt;
gt; =Average of the 5 numbers above
gt;
gt; Can I actually use goal seek so that I can change my average to another
gt; number by changing say the sum total?
gt;
gt; Thanks for your time
gt; From John
gt;
gt;

--
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: www.excelforum.com/member.php...oamp;userid=30329
View this thread: www.excelforum.com/showthread...hreadid=517079David,

quot;Janice Blanksquot;

is trying to find you....

Berniequot;David J. Bradenquot; gt; wrote in message
...
gt; In line with the other responses, use algebra. If your data are in cells
gt; A1:A5, and the quot;target averagequot; is in cell B1, then in cell C1 enter
gt; =COUNT(A1:A5)*(B1-AVERAGE(A1:A5))
gt; to get a number by which you must adjust cells. You can add/subtract it
gt; from one of your cells, or spread out the quot;correctionquot;.
gt;
gt; DaveB
gt;
gt; Neo1 wrote:
gt;gt; Hello just a problem I have which I cant seem to get right...
gt;gt;
gt;gt; I have the following numbers:
gt;gt;
gt;gt; 5
gt;gt; 6
gt;gt; 9
gt;gt; 24
gt;gt; 56
gt;gt; =Sum of all those numbers above
gt;gt;
gt;gt; =Average of the 5 numbers above
gt;gt;
gt;gt; Can I actually use goal seek so that I can change my average to another
gt;gt; number by changing say the sum total?
gt;gt;
gt;gt; Thanks for your time
gt;gt; From John
gt;gt;
gt;gt;
gt;
gt; --
gt; 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:
quot;my data are in cells A1 through A5, and their average is calculated in
cell B1 with quot;=AVERAGE($A$1:$A$5)quot;. 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?quot;

DaveB

David J. Braden wrote:
gt; In line with the other responses, use algebra. If your data are in
gt; cells A1:A5, and the quot;target averagequot; is in cell B1, then in cell C1
gt; enter =COUNT(A1:A5)*(B1-AVERAGE(A1:A5))
gt; to get a number by which you must adjust cells. You can add/subtract it
gt; from one of your cells, or spread out the quot;correctionquot;.
gt;
gt; DaveB
gt;
gt; Neo1 wrote:
gt;gt; Hello just a problem I have which I cant seem to get right...
gt;gt;
gt;gt; I have the following numbers:
gt;gt;
gt;gt; 5
gt;gt; 6
gt;gt; 9
gt;gt; 24
gt;gt; 56
gt;gt; =Sum of all those numbers above
gt;gt;
gt;gt; =Average of the 5 numbers above
gt;gt;
gt;gt; Can I actually use goal seek so that I can change my average to another
gt;gt; number by changing say the sum total?
gt;gt;
gt;gt; Thanks for your time
gt;gt; From John
gt;gt;
gt;gt;
gt;

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