# Help with using average function

#### jdmbo1

##### New Member
Hello,
I have numbers filled from A1-A50. I want to average A1-10, then A11-20; etc. all the way to 50. I tried to just do one average A1:A10, then extend it downwards, but for some reason, the formula that follows is A2:A11, A3:A12. My question is if there's an easier way to accomplish finding the average between A1-A50, at 10 number intervals?

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### Ron Coderre

##### MrExcel MVP
Now, I just answered this question over at the other forum you posted it to 10 minutes prior to your posting it here. I'm a little annoyed that you'd have TWO teams of experts working on the same question at the same time when one of those teams could be addressing other questions and helping other people. Please pick the one group in the one forum you think is best and let that group have a few hours to get to your issue. Remember, we help here because we enjoy helping...It's certainly not for the money!

BTW...here's what I posted there:

Last edited:

#### indiantrix

##### Well-known Member
try this: =IF(MOD(ROW(),10)=0, AVERAGE(A1:A10),"") in column B, and copy down.
You'll get some errors in the first 9 rows, but the cell will still display what you need:
a blank cell. The first average would appear in row 10, and so on.
HTH Larry.

#### jdmbo1

##### New Member
Thanks for the help indiantrix, Ron Coderre has already helped me with this problem on a different forum.

Replies
6
Views
252
Replies
11
Views
395
Replies
25
Views
715
Replies
3
Views
278
Replies
8
Views
300

1,191,717
Messages
5,988,256
Members
440,145
Latest member
arxoon

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back