Let’s say i have this situation:
sheet.ods (21.1 KB)
Is it possible to get the number of weeks (a week is 7 consecutive days) that have the value 0 each day? I mean, if there are are 8 consecutive days, it would be 1 week, not 2, and to count the next week the one already calculated must be excluded.
In the file uploaded, the result should be 3, not 6.
Is it possible? Thank you.
@Villeroy
That’s the issue, you got 6 weeks, not 3, the ones already calculated are not excluded.
I guess it’s not possible to write a function for a whole year, right?
@mikekaganski
Now, do i have to this separately for each column, or is there a way to do it for a column at once?
I have 55 columns.
Calc has 16000+ columns - enough for the task.
I can imagine an array formula - very complex one - which would be undebuggable, and therefore unmaintainable. My advice would be - use cells and columns, that allow you to find errors when they appear.