I'm trying to calculate the average of every five rows. I have a formula =Average(A1:A5) in cell B1. When I do an autofill in B2, the formula would read =Average(A2:A6). What I actually want it to be is =Average(A6:A10), increments of 5. I don't know what i'm doing wrong. I have also tried selecting all the B rows and doing autofill and that still doesn't work. Please help! Thanks
Last edited by kguillen; 04-07-2009 at 07:18 AM.
Try...
B1, copied down:
=AVERAGE(INDEX($A$1:$A$100,ROWS(B$1:B1)*5-5+1):INDEX($A$1:$A$100,ROWS(B$1:B1)*5))
Adjust the range, accordingly.
Thank you so much Domenic! you saved me a lot of work.
You're very welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks