- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Re: Averaging data

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.

None

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