I have a long colum of numbers,in row A. I would like to average every 4
numbers such as 1-4, 2-6, 3-7, 4-8 etc. and have the answer show in row B
next to the last averaged number. Can someone help me..

One way:

B1: =IF(MOD(ROW(),4)=0,AVERAGE(OFFSET(A1,-3,0,4,1)),"")

Copy down as far as needed.



In article <0aXwd.195922$(E-Mail Removed)>,
"Donduk" <(E-Mail Removed)> wrote:

> I have a long colum of numbers,in row A. I would like to average every 4
> numbers such as 1-4, 2-6, 3-7, 4-8 etc. and have the answer show in row B
> next to the last averaged number. Can someone help me..

=SUM(INDEX(A1:A4,0):INDEX(A1:A4,0))/4

into cell B4. Is not volatile and works if you move rows.

HTH,
Bernd

Isn't this the same thing:

=SUM(A1:A4)/4

In B4, and drag down to copy?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bernd Plumhoff" <(E-Mail Removed)> wrote in message
news:cq36jf$1pv$04$(E-Mail Removed)...
> =SUM(INDEX(A1:A4,0):INDEX(A1:A4,0))/4
>
> into cell B4. Is not volatile and works if you move rows.
>
> HTH,
> Bernd
>
>

Hi Ragdyer,

You are right. If we want to be independent to insertion of rows (which
means if we want to have an average of this row and the 3 previous rows in
column A) we need =SUM(INDEX(A:A,ROW()-3):INDEX(A:A;A4))/4 I think :-)

Regards,
Bernd

I'm sorry, but perhaps today I'm a little more dense then I usually am.
I don't see your point in the necessity of using Index().
Besides, I couldn't get your formula to work.

How about this one:

=AVERAGE(INDIRECT("A"&ROW()-3&":A"&ROW()))
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Bernd Plumhoff" <(E-Mail Removed)> wrote in message
news:cq51po$ceg$03$(E-Mail Removed)...
> Hi Ragdyer,
>
> You are right. If we want to be independent to insertion of rows (which
> means if we want to have an average of this row and the 3 previous rows in
> column A) we need =SUM(INDEX(A:A,ROW()-3):INDEX(A:A;A4))/4 I think :-)
>
> Regards,
> Bernd
>
>