Re: Averaging previous cells

=AVERAGE($A$1:A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mrobertson" <mrobertson.1yce2m_1131729005.998@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:mrobertson.1yce2m_1131729005.998@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I currently have a list of data with several values. I want to add a
> colunm with which the first row will be the average of that
> column(hence just that value), the second row will be the average of
> the second row and the first row, the third row will be the average of
> the first second and third row. Can anyone help me as to how I would
> be able to do this?
>
> ex) I need something that increment the 2nd term in the average
> function:
>
> average(A1:A1)
> average(A1:A2)
> average(A1:A3)
> average(A1:A4)
> average(A1:A5)
> average(A1:A6)
>
>
> --
> mrobertson
> ------------------------------------------------------------------------
> mrobertson's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=28744
> View this thread: http://www.excelforum.com/showthread.php?threadid=484329
>


.

Relevant Pages

  • txt2xls
    ... This should go in the first row, ... first column. ... This should go in the second row, ... This should go in the third row, ...
    (comp.lang.python)
  • Re: txt2xls
    ... > This should go in the first row, ... > first column. ... > This should go in the second row, ... > This should go in the third row, ...
    (comp.lang.python)
  • Re: Murphy for Matrices
    ... first row 1,2,3,4 ... second row 1,2,4,8 ... third row 2,3,5,7 ... fourth will be totally random, just to be safe 1,-1,0,1 ...
    (sci.math)
  • Fill Handle Capabilities
    ... In the first row I ... typed C1, second row C2, third row C3, etc. ... Does Word have fill handle capabilities? ...
    (microsoft.public.word.docmanagement)
  • Re: Row and Col property of MSHFlexGrid
    ... Private Sub MSHFlexGrid1_Click ... For the first table, if I click on the first row, no dialog pops up. ... the "data" of the second row. ... When the grid has focus, ...
    (microsoft.public.vb.controls)
Loading