SUM FORMULA- skipping every seventh row
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
|