[FONT="]Columns- count a consecutive series of positive or negative numbers and then get a sum of the max frequency [/FONT]
[FONT="]
Example:
<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>max positive count is 4 and the sum is 17.
max negative count is 5 and the sum is -10
Looking for excel array formula please for Microsoft office 2016.
Thanks!
[/FONT]
[FONT="]
Example:
A | B | C | D | E | F | G | H | I | J | K | L | M |
-1 | -2 | -3 | 1 | 3 | 5 | 8 | 0 | -1 | -3 | -1 | -1 | -4 |
<tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">
</tbody>
max negative count is 5 and the sum is -10
Looking for excel array formula please for Microsoft office 2016.
Thanks!
[/FONT]