hi, i am trying to create a formula that adds up six cells in a column and gives a total in a different table, then i need it to skip the seventh cell and then add the next six and give another total, and so on..
I need a formula that i can drag down and have it autofill pretty much forever.

Im on a steep excel learning curve, can someone please explain how i write a formula to skip the seventh cell?

cheers