## [Solved] Sum total of every 3rd row

### [Solved] Sum total of every 3rd row

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
Last edited by MrProgrammer on Sun Dec 01, 2019 6:06 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
openoffice 4.1
sharon29

Posts: 3
Joined: Sat Nov 30, 2019 6:19 pm

### Re: SUM TOTAL OF EVERY 3RD ROW

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.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.

RusselB
Moderator

Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

### Re: SUM TOTAL OF EVERY 3RD ROW

B6:B200: =MOD(ROW();3)
=SUMIF(B6:B200;0;A6:A200)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: SUM TOTAL OF EVERY 3RD ROW

Thanks for the help i really need sumtotal in A1 without other values in b column.

What are helper columns to track 3rd rows ?
openoffice 4.1
sharon29

Posts: 3
Joined: Sat Nov 30, 2019 6:19 pm

### Re: SUM TOTAL OF EVERY 3RD ROW

This is most fundamental spreadsheet knowledge. [Tutorial] How do I specify the formula for a column?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: SUM TOTAL OF EVERY 3RD ROW

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
Mr. Programmer
AOO 4.1.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA).

MrProgrammer
Moderator

Posts: 3953
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

### Re: Sum total of every 3rd row

Thanks my programmer, that works, u have saved me another 3 hours trying to solve it, thanks again.
openoffice 4.1
sharon29

Posts: 3
Joined: Sat Nov 30, 2019 6:19 pm