Into C27 enter the formula
and copy te formula to range C27:C31.

Other 1's (in rows 24:25) aren't essential, as by your setup the value1 in row 26 is always having mathing 2 values in rows 24:25 in same column, or in next one.

Thanks for the quick reply!

The other 1's are still essential because if C26 = 1, D24 = 1 but D25 = 0, there is no refund. Refund is only given if there's 2x 1's mated to the "away over night" 1's, sometimes there may be only one "1" mated to the "away over night" or maybe only one "1" in the "away over night", but None mated to it, you know what I mean?

That's the Problem I'm having.