|Subject:||Re: Averaging data|
|Posted by:||T. Valko (biffinpi…@comcast.net)|
|Date:||Fri, 11 Jul 2008|
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:
Microsoft Excel MVP
<alboi…@gmail.com> wrote in message
> 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,
Averaging data posted by alboi…@gmail.com on Fri, 11 Jul 2008