Re: Averaging data

Giganews Newsgroups
Subject: Re: Averaging data
Posted by:  T. Valko (biffinpi…@comcast.net)
Date: Fri, 11 Jul 2008

Try this:

Assume the values to be averaged are in column A starting at cell A1.

Enter this formula in C1 and copy down as needed:

=AVERAGE(OFFSET(A$1,(ROWS(C$1:C1)-1)*8,,8))

This will evaluate as:

C1: =AVERAGE(A1:A8)
C2: =AVERAGE(A9:A16)
C3: =AVERAGE(A17:A24)
etc
etc

--
Biff
Microsoft Excel MVP

<alboi…@gmail.com> wrote in message
news:ccb3d403-7859-4e14-a5ed-bf0edf4056…@8g2000hse.googlegroups.com...
> Hi,
>
> I have a really long column which contains numerical entries. What I
> want to be able to do is to average these values in sets of 8, for
> example. What I mean is that the average of the first 8 entries needs
> to be calculated, and the result displayed in the next column. Then
> the average of the second set of 8 entries needs to calculated and
> displayed in the same next column. An so on. How could this be done?
> Any suggestion is greatly appreciated.
>
> Thank you,
>
> Alex.

Replies

None

In response to

Averaging data posted by alboi…@gmail.com on Fri, 11 Jul 2008