total column amounts from non-contiguous rows

[Guest]

I'm trying to total amounts in a column from rows that are not contiguous (4
rows apart). Since there are over 100 entries, I'd rather not have to "add"
each row using the simple =C1+C4+C8+C12.....etc Is there a way to do this?

 

[Guest]

=SUM(IF(MOD(ROW(C1:C100),4)=0,C1:C100))+C1

ctrl+shift+enter, not just enter
Adjust your range to suit

 

[Guest]

Try:

=SUM(IF(MOD(ROW(C1:C100)-1,4)=0,C1:C100))

Entered with Ctrl+Shift+Enter (you will get {} round the formula).


C1+C5+C9 etc NOT C1+C4 +C8

HTH

 

[Ragdyer]

Your choice of which rows to total is unclear, since your example is:
1, 4, 8, 12, ...etc.
BUT
you mention <<< 4 rows apart >>>.

Here are some *regular* entry suggestions, *no* CSE required:

1, 5, 9, 13 ... etc.
=SUMPRODUCT((MOD(ROW(C1:C100),4)=1)*(C1:C100))

4, 8, 12, 16 ...etc.
=SUMPRODUCT((MOD(ROW(C1:C100),4)=0)*(C1:C100))

AND - your *uneven* example,
1, 4, 8, 12 ... etc.
=C1+SUMPRODUCT((MOD(ROW(C1:C100),4)=0)*(C1:C100))