average sum of 5rows

B

bill gras

Hi All

I have a column of 1020 rows with numbers , I need to average the sum
of every 5 rows down to 1020 rows eg-
a d
1 52
2 60
3 64
4 40
5 71 57.6
6 203
7 150
8 11
9 25
10 93 96.4

Can any one help me please
Thanks in advance
 
T

T. Valko

One way...

Assume data starts in cell A2. Enter this formula in B2 and copy down:

=IF(MOD(ROWS(B$2:B2),5),"",AVERAGE(OFFSET(A2,,,-5)))
 
J

Jacob Skaria

In D5 enter the below formula and copy down as required
=IF(MOD(ROW(),5),"",AVERAGE(A1:A5))

If this post helps click Yes
 
T

Teethless mama

In D1: =IF(MOD(ROW(),5)=0,AVERAGE(OFFSET(A1,,,-5,)),"")

copy down as far as needed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top