incrementing cells in SUM

[cristianzisu]

Hello,
I need your help for making a formula
For example, i have to sum the cells F14, F20, F26 and so on ..... F...
So, they are incrementing by 6. And a need a formula for this, beacuse the document is so large and i can't type F14+F20+F26......+F25000


Thank you!

[shukla.ankur281190]

Try

Add a helper column G

G1=MOD(ROWS($G$14:G14),6) and drag down it will give you serial nos like 1,2,3,4,5,0,1,2,3,4,5,0 . 1 is the criteria which need to add.

Now for Sum Try

=SUMIFS(F:F,G:G,1)

[samba_ravi]

=SUMPRODUCT(--(MOD(ROW(F14:F2250)-14,6)=0),F14:F2250)

Please Login or Register  to view this content.

try this