title: skipping cells in excel whilst doing an average
body: <p>so i need help with excel. I have data that i am trying to analyse and there is just too much so i am trying to cut it down. I am trying to get an average once per 5 cells. so i have </p>
  
  <p>=SUM(AB2:AB6)/5</p>
  
  <p>i want to use this formula for over 30,000 cells but i want to skip 4 cells each time. is there any way i can do this, like how you would drag the cursor down if you just wanted to continue but by missing 4 cells each time?</p>
  
  <p>any help would be hugely appreciated,</p>
  
  <p>Heather.</p>