Hello, I want to try and sum a streak for both positive and negative numbers, but once the streak stops, it will restart a new sum. As you can see in row B2, If I input a positive number, I want a formula to sum it in B3, if it is a negative number, it will sum it in B4.
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
<tbody>
</tbody>
Thank you for taking the time to read this, look forward to hearing from you.
Best Regards,
Vlad
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