Averaging data

  • Thread starter Thread starter alboika
  • Start date Start date
A

alboika

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.
 
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
 
Assuming Row 1 has headers, and we are looking at Column A......

In B9 enter =AVERAGE(A2:A9)
Highlight cells B2:B9 and then copy down as far as you require.

Sandy
 
Not as elegant but non-volatile:

=AVERAGE(INDEX($A$1:$A$800,ROW()*8-8+1):INDEX($A$1:$A$800,ROW()*8))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top