Page 1 of 1

[Solved] Sum total of every 3rd row

PostPosted: Sat Nov 30, 2019 6:24 pm
by sharon29
Hi in A6 TO A200 i have values inputted into cells,
In A1 would like the sumtotal of every 3rd cell.

Is there any other formula rather than A6+A9+A12+A15 etc
Thanks
Sharon

Re: SUM TOTAL OF EVERY 3RD ROW

PostPosted: Sat Nov 30, 2019 6:37 pm
by RusselB
Welcome to the forums.
While there are other ways of doing it, since you have a specific limited number of rows to contend with, using the formula format you suggested is the simplest.
Coming in a close 2nd, imo, is to use the SUM function, with the cell addresses entered with a semi-colon between them.. again, you'd need to enter each cell address.
Coming in at 3rd place would require the usage of a helper column that tracks the value for each 3rd row. If you need more help with that, let us know.

Re: SUM TOTAL OF EVERY 3RD ROW

PostPosted: Sat Nov 30, 2019 6:39 pm
by Villeroy
B6:B200: =MOD(ROW();3)
=SUMIF(B6:B200;0;A6:A200)

Re: SUM TOTAL OF EVERY 3RD ROW

PostPosted: Sat Nov 30, 2019 7:09 pm
by sharon29
Thanks for the help i really need sumtotal in A1 without other values in b column.

What are helper columns to track 3rd rows ?

Re: SUM TOTAL OF EVERY 3RD ROW

PostPosted: Sat Nov 30, 2019 8:39 pm
by Villeroy
This is most fundamental spreadsheet knowledge. [Tutorial] How do I specify the formula for a column?

Re: SUM TOTAL OF EVERY 3RD ROW

PostPosted: Sat Nov 30, 2019 8:59 pm
by MrProgrammer
Hi, and welcome to the forum.

sharon29 wrote:Is there any other formula rather than A6+A9+A12+A15 etc
=SUMPRODUCT(A6:A200;MOD(ROW(A6:A200);3)=0)

[Tutorial] The SUMPRODUCT function, example X11

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

Re: Sum total of every 3rd row

PostPosted: Sun Dec 01, 2019 1:49 pm
by sharon29
Thanks my programmer, that works, u have saved me another 3 hours trying to solve it, thanks again.