Show average at front of list

S

Scott Bishop

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.
 
G

gjcase

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
 
B

Bob Phillips

yes, just start with B

=AVERAGE(B2:M2)

in A2 for instance

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
C

CLR

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
 
S

Scott Bishop

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
 
B

Bob Phillips

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