Vishal Srivastava
Member
Hello Experts
Looking for your help!
Here is my problem:
I want to SUM consecutive negative numbers upto 4 consecutive cells in next row.
If positive comes then it should skip the sequence and checks for the next sequence like as below:
please help.
Waiting for your solution.
Thanks in advance.
Looking for your help!
Here is my problem:
-20 | -30 | -40 | 50 | 60 | -70 | -80 | -90 | -20 | -50 |
I want to SUM consecutive negative numbers upto 4 consecutive cells in next row.
If positive comes then it should skip the sequence and checks for the next sequence like as below:
-20 | -50 | -90 | 50 | 60 | -70 | -150 | -240 | -260 | -50 |
please help.
Waiting for your solution.
Thanks in advance.