Re: Averaging data

Giganews Newsgroups
Subject: Re: Averaging data
Posted by:  T. Valko (biffinpi…
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:


This will evaluate as:

C2: =AVERAGE(A9:A16)
C3: =AVERAGE(A17:A24)

Microsoft Excel MVP

<alboi…> wrote in message
> 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.



In response to

Averaging data posted by alboi… on Fri, 11 Jul 2008