Calculate Every 4th Cell Down!
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.
"Killer" wrote:
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
|