Calculate Every 4th Cell Down!

[Killer]

Hey!

Need something that will Calculate evrey 4th cell without using this long
process formula because this is required down the whole sheet.

=C9+C13+C17+C21

Example:

Total = 9

C9 = 1
C13 = 1
C17 = 5
C21 =2

 

[Qull666]

You can try this:
Create a helper cell in Column D.
In Cell D9, enter this formula: =IF(MOD(ROW()-5,4)=0,C9,"-")
Copy downwards.

HTH.

 

[Qull666]

Correction:
=IF(MOD(ROW()-1,4)=0,C9,"-")

 

[T. Valko]

Try this:

=SUMPRODUCT(--(MOD(ROW(C9:C100)-ROW(C9),4)=0),C9:C100)