Help with using average function

[jdmbo1]

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?

 

[Ron Coderre]

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:
http://www.excelforum.com/showthread.php?p=2058828#poststop

 

[indiantrix]

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]

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