Addition of Data in rows with fixed interval in Libreoffice Calc

[sibi.kanagaraj]

Assuming that I am having 200 rows and 2 coulmns in a Spreadsheet .

A1 B1
A2 B2

A200 B200

My question is , will I be able add values B2,B15,B28,… (Interval of 13) without using Control button to click them individually ?

[PYS]

HI - You can try:

=SUMPRODUCT(B1:B200;(MOD(ROW(B1:B200)-2;13)=0))

See SumIncrement.ods

[karolus]

@PYS it seems the OP want the Opposite not pull out Data from row-interval, but put in Data in Interval??

in that case I’m missing some Information where did the Data come from to put in every 13 row

[karolus]

@PYS it seems the OP want the Opposite not pull out Data from row-interval, but put in Data in Interval??

in that case I’m missing some Information where did the Data come from to put in every 13 row