Average fonction!!

  • Thread starter Thread starter cosmin100
  • Start date Start date
C

cosmin100

Hi, I have about 500 values and I will like to have an average of
values at at time. So I would get the average of the first 8 value
and then of the next 8 values and so on.
Thanks guys cause I looked all morning and I cannot find it!:confused
 
here is an inefficiant way of doing it, I'd try to give you a bette
way, but I am done with work now...


assuming your 500 values are $a$1:$a$500
in cell b8 enter the following:

=average(a1:a8)

Then copy cells b1 to b8 and select column b until cell 496 (div by
or 504 or as close as you can get to the end with the total cells bein
div by 8 and copy it down, now in column b you should have the average
for every 8 cells in the big list, sparsed intermittetedly
 
Try this:

Create a column of data somewhere, say starting in C1.

C1: 1
C2: =C1+8
C3: =C2+8

and so on until you hit close to 500.

Assuming your data is in A1:A500,

in D1: =average(indirect("A"&C1):indirect("A"&(C1+7)))

Then, just drag that formula down for the rest of the cells
 
Back
Top