I am trying to create a gradebook. I would like for the average to show at
the front of the list of numbers rather than the end. Is this possible?
Thank you.
Yes. Create the average as you normally would, then drag the cell to
the new position at the top of the data. (Make sure there's an empty
cell there to put it in, you don't want to overwrite your data. Also
make sure that the cell you are dragging to is not part of the range
you are averaging or you will end up with a circular reference.
---GJC--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=528673yes, just start with B
=AVERAGE(B2:M2)
in A2 for instance
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Scott Bishopquot; lt;Scott gt; wrote in message
...
gt; I am trying to create a gradebook. I would like for the average to show
at
gt; the front of the list of numbers rather than the end. Is this possible?
gt; Thank you.
The Average, is just the result of a formula. The formula can be put in any
cell in the sheet. For instance if your range of grades were in cells c5 to
H5, then in cell A5 you could put =AVERAGE(C5:H5)
hth
Vaya con Dios,
Chuck, CABGx3
quot;Scott Bishopquot; wrote:
gt; I am trying to create a gradebook. I would like for the average to show at
gt; the front of the list of numbers rather than the end. Is this possible?
gt; Thank you.
I apologize for my lack of clarity. I would like to keep adding grades at
the end of the list without having to update the range of cells, but I would
like for the average to show at the front. Is that configuration possible?
Thank you
quot;Scott Bishopquot; wrote:
gt; I am trying to create a gradebook. I would like for the average to show at
gt; the front of the list of numbers rather than the end. Is this possible?
gt; Thank you.
Yes, as before, in A2 enter =AVERAGE(B2:M2)
change the M2 to the last cell you will possibly use. Average ignores
blanks.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Scott Bishopquot; gt; wrote in message
...
gt; I apologize for my lack of clarity. I would like to keep adding grades at
gt; the end of the list without having to update the range of cells, but I
would
gt; like for the average to show at the front. Is that configuration
possible?
gt; Thank you
gt;
gt; quot;Scott Bishopquot; wrote:
gt;
gt; gt; I am trying to create a gradebook. I would like for the average to show
at
gt; gt; the front of the list of numbers rather than the end. Is this possible?
gt; gt; Thank you.
the front of the list of numbers rather than the end. Is this possible?
Thank you.
Yes. Create the average as you normally would, then drag the cell to
the new position at the top of the data. (Make sure there's an empty
cell there to put it in, you don't want to overwrite your data. Also
make sure that the cell you are dragging to is not part of the range
you are averaging or you will end up with a circular reference.
---GJC--
gjcase
------------------------------------------------------------------------
gjcase's Profile: www.excelforum.com/member.php...oamp;userid=26061
View this thread: www.excelforum.com/showthread...hreadid=528673yes, just start with B
=AVERAGE(B2:M2)
in A2 for instance
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Scott Bishopquot; lt;Scott gt; wrote in message
...
gt; I am trying to create a gradebook. I would like for the average to show
at
gt; the front of the list of numbers rather than the end. Is this possible?
gt; Thank you.
The Average, is just the result of a formula. The formula can be put in any
cell in the sheet. For instance if your range of grades were in cells c5 to
H5, then in cell A5 you could put =AVERAGE(C5:H5)
hth
Vaya con Dios,
Chuck, CABGx3
quot;Scott Bishopquot; wrote:
gt; I am trying to create a gradebook. I would like for the average to show at
gt; the front of the list of numbers rather than the end. Is this possible?
gt; Thank you.
I apologize for my lack of clarity. I would like to keep adding grades at
the end of the list without having to update the range of cells, but I would
like for the average to show at the front. Is that configuration possible?
Thank you
quot;Scott Bishopquot; wrote:
gt; I am trying to create a gradebook. I would like for the average to show at
gt; the front of the list of numbers rather than the end. Is this possible?
gt; Thank you.
Yes, as before, in A2 enter =AVERAGE(B2:M2)
change the M2 to the last cell you will possibly use. Average ignores
blanks.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Scott Bishopquot; gt; wrote in message
...
gt; I apologize for my lack of clarity. I would like to keep adding grades at
gt; the end of the list without having to update the range of cells, but I
would
gt; like for the average to show at the front. Is that configuration
possible?
gt; Thank you
gt;
gt; quot;Scott Bishopquot; wrote:
gt;
gt; gt; I am trying to create a gradebook. I would like for the average to show
at
gt; gt; the front of the list of numbers rather than the end. Is this possible?
gt; gt; Thank you.
