So you may have some cells not filled jet? Then I'm afraid you are ot of luck!



Imagine a case, you have a cotinous row of dates with all 3 rows having 1 entered, and somewhere in middle cells in row 24:25 in some column are unchecked. You have go back to first column with 1 in row 26, and then check the full path back until the column with empty cells to decide, do those belong to this or previous column. Add one checked column more, and you have a step more to calculate.

Probably you have to add 2 more rows - 2 meals from current day, a night, and 2 meals from next day. And in column you can have 3 1's altogether.

How so? This is about a formula, you don't have to know what the texts mean

Yes, every month different cells are gonna be either blank or have a 1 in them.. It always belongs to the column where row 26 has a 1 in it. I'll try the more rows Thing but I'm not sure about it.

An example:
Now the question is, do belong these empty cells to DayB, or to DayC? No way to decide based only on DayB : DayC columns, without processing all days at least from start of block of 1's, when not from start of table. And what when the block starts with halfway filled data? P.e. in my example in column DayA the row 24 is empty, but really not filled jet.

Hello

The empty cells should belong to Day B

So I have 3 extra rows now with:

1) 2 Meals before night (easiest, no help needed with this one)
2) 1 Meal before and after night
3) 2 Meals after night

So it now just counts those 3 "possibilities" and I have them on paper now. What I now Need is some Kind of Formula that can calculate if there's only one refund or two in complicated cases like this one:

Row ... .......A......B......C.......D.......E ...
24 .............................1
25 ......................1......1
26 ......................1......1
...
30 ......................>Formula<


My Problem is this:

The example up there is one refund, right? Because B26, C24, C25 are one refund OR C24,C25,C26 could be one refund, but it's only one of either. The way I'm going now, it recognizes "B" and "C" as a refund, which I don't want.. So I would Need something like: If B30 is 1 due to C24 and C25 belonging to it, then don't put 1 in C30

Does something like this exist? I can upload the file again if you want.