Weekly Sums From Daily Column Data

English
#1

I have daily totals in columns by date, spanning a three year time period. I need to get week totals by date. Have been doing it manually but it takes forever. Is there a function for this?
Thank you.

#2

Do you mean the famous DOWHATIHAVEINMIND() function? :wink:
Being serious again: The design you are describing in short will mot be actually recommended by experienced users.

How to get what you want nevertheless may depend on this and that.
Is there a column for every day or arte there days left out (holydays
)?
A reduced example sheet showing the complete design/situation and explicitly explaining the assurances you can give, and the indispensable needs you see would help.

#3

Yes, the DOWHATIHAVEINMIND function, exactly!

One column, with, say, 1000 numbers. I wish every group of seven numbers to be summed. So if the column is ‘how many apples per day’, I wish to translate this into ‘how many apples per week’. Been doing it by inserting a row every seven rows, and summing manually, but handling sheets that have hundreds of thousands of cells


Thanks, I appreciate the reply you left.

#6

I obviously still don’t understand. You are talking of “every seventh row” on the one hand, related to the seven days of a week supposedly, but of “hundreds of thousands of cells” on the other hand. Where are all the many cells?

Well, I had also sketched a suggestion, but didn’t post it then because you seemed satisfied with the solution @karolus had suggested. Now I added a second sheet to that solution, and attach the spreadsheet document here. You may check.
disask99167weeklyTotalsFromDailyTotals.ods (36.7 KB)

Pivot tables have many advantages, but there are some disadvantages, too - at least as long as you don’t consider to include a bit of user code:
Formatting and missing AutoCalc, e.g.

1 Like
#7

Awesome, thanks. I meant, doing it the hard way, I would insert a row after every seventh row, to sum the previous seven rows
manually.

#4

See attached example,
there is a calculated Column C with »weeknums«
And the pivot-table is grouped by date→Year,

pivot_aggregatet_by_weeknum_and_year.ods (64.0 KB)

1 Like
#5

Ok, I can figure that out. Thank you.

Impressum (Legal Info) | DatenschutzerklĂ€rung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.