SUM FORMULA- skipping every seventh row

[bite_tony]

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

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

cheer

 

[Bruno Campanini]

bite_tony was thinking very hard :

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?

=NOT(MOD(ROW(A7),6))+SUM(A$1:A7)
OR
=NOT(MOD(ROW(A7),6))+SUM(A1:A7)
Formulas to be copied in every 7th cells.

OR
=--NOT(MOD(ROW(A1),7))*(NOT(MOD(ROW(A1),6))+SUM(A1:A7))
Formula to be copied in every cells

Uncheck "Show a zero in cells that have zero value"

Bruno