Hey all,

I'm having issues with averaging numbers from a list. I have a list of approximately 2000 values that need to be averaged in clumps of 6. When I create an average formula in a second column with the the first few equations being as such: =Average(W9:W14); =Average(W15:W20); =Average(W21:W26), then highlight the three boxes and drag the right corner down a few rows, I get repeating groupings of three boxes that average 6 numbers each but are not consecutive.

Here's what I'm returning:
=Average(W9:W14); =Average(W15:W20); =Average(W21:W26)
=Average(W12:W17); =Average(W18:W23); =Average(W24:29)
=Average(W15:W20); =Average(W21:W26); =Average(W27:W32)
=Average(W18:W23); =Average(W24:W29); =Average(W30:W35)

And here is what I would like to return:
=Average(W9:W14); =Average(W15:W20); =Average(W21:W26)
=Average(W27:W32); =Average(W33:W38); =Average(W39:44)
=Average(W45:W50); =Average(W51:W56); =Average(W57:W62)
=Average(W63:W68); =Average(W69:W74); =Average(W75:W80)

Any help would be wonderful.