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: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528673

yes, just start with B

=AVERAGE(B2:M2)

in A2 for instance

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Scott Bishop" <Scott wrote in message
...
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.

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



"Scott Bishop" wrote:

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.

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

"Scott Bishop" wrote:

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, 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)

"Scott Bishop" wrote in message
...
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

"Scott Bishop" wrote:

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.