[Solved] Sum total of every 3rd row

Discuss the spreadsheet application

[Solved] Sum total of every 3rd row

Postby sharon29 » Sat Nov 30, 2019 6:24 pm

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

Postby RusselB » Sat Nov 30, 2019 6:37 pm

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.
User avatar
RusselB
Moderator
 
Posts: 5854
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: SUM TOTAL OF EVERY 3RD ROW

Postby Villeroy » Sat Nov 30, 2019 6:39 pm

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
User avatar
Villeroy
Volunteer
 
Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: SUM TOTAL OF EVERY 3RD ROW

Postby sharon29 » Sat Nov 30, 2019 7:09 pm

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

Postby Villeroy » Sat Nov 30, 2019 8:39 pm

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
User avatar
Villeroy
Volunteer
 
Posts: 27760
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: SUM TOTAL OF EVERY 3RD ROW

Postby MrProgrammer » Sat Nov 30, 2019 8:59 pm

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).
User avatar
MrProgrammer
Moderator
 
Posts: 3953
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Sum total of every 3rd row

Postby sharon29 » Sun Dec 01, 2019 1:49 pm

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


Return to Calc

Who is online

Users browsing this forum: MSN [Bot] and 7 guests