In cell D3, it sums a total of 13 which was the total sum of positive numbers before the streak ended. Then there is a negative streak that ends in cell H4, the positive streak resumes in cell I3 and starts a new sum count, it does not include the streak in cell B3:D3

Is there a formula I can input in cell B3 and B4, I don’t want the formula to include the total in cell G3, G4, M3, M4. I would like the formula to ignore these cells because I just want the streak sum from Monday to Friday calculated carrying over the the next week as seen in the example

A | B | C | D | E | F | G | H | I | J | K | L | M | |

1 | Monday | Tuesday | Wednesday | Thursday | Friday | Total | Monday | Tuesday | Wednesday | Thursday | Friday | Total | |

2 | input Number | 5 | 5 | 3 | -5 | -5 | -5 | 4 | 5 | 5 | -5 | ||

3 | positive streak | 5 | 10 | 13 | 13 | 4 | 9 | 14 | 14 | ||||

4 | negative streak | -5 | -10 | -10 | -15 | -5 | -10 |

<tbody>

</tbody>

Thank you for taking the time to read this, look forward to hearing from you.

Best Regards,

Vlad