Hi,
I wanted to know how to sum the longest negative and positive sum within one column with these 5 data points as the example -1-6+10-5+3 , ill show example below.
in this column, you can see the largest negative sum was -7, -1-6=-7, at no other point did the negative sum throughout the -1-6+10-5+3 sum go larger than -7.
in the same column, the largest positive sum, -1-6+10=+3, at no other point did the positive sum throughout the -1-6+10-5+3 sum go larger than +3,,,
is there a way to have two formulas that can sum the largest negative sum -7 and the largest positive sum +3 in this column of 5 numbers?
thanks!
I wanted to know how to sum the longest negative and positive sum within one column with these 5 data points as the example -1-6+10-5+3 , ill show example below.
-1 |
-6 |
10 |
-5 |
3 |
largest negative sum = -7 |
largest positive sum = +3 |
in this column, you can see the largest negative sum was -7, -1-6=-7, at no other point did the negative sum throughout the -1-6+10-5+3 sum go larger than -7.
in the same column, the largest positive sum, -1-6+10=+3, at no other point did the positive sum throughout the -1-6+10-5+3 sum go larger than +3,,,
is there a way to have two formulas that can sum the largest negative sum -7 and the largest positive sum +3 in this column of 5 numbers?
thanks!