Ask Your Question
1

SUM every 5th column

asked 2018-09-12 13:15:16 +0100

KrpaN gravatar image

updated 2018-09-12 16:39:18 +0100

kompilainenn gravatar image

I have a LO Calc table for a competition. There are 4 columns for the 4 weeks of the first month followed by a 5th column for the monthly best result out of the previous four weeks, followed by another 4 columns for the 4 weeks of the next month and followed by another column for the monthly best result out of the previous four weeks, etc, up to 12 months. What I need is best monthly result out of four previous weeks, and a sum of five best results of all months. I searched a lot and tried many examples but with no satisfying result. Any help would be appreciated.

Sample file: https://ask.libreoffice.org/upfiles/1...

edit retag flag offensive close merge delete

Comments

Please share a file sample with what you like and how data are in.

m.a.riosv gravatar imagem.a.riosv ( 2018-09-12 13:36:58 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-09-12 16:21:30 +0100

KrpaN gravatar image

Attached is an Example file with description therein.C:\fakepath\Example.ods

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-09-12 13:15:16 +0100

Seen: 34 times

Last updated: Sep 12 '18