'Using SumIF for first 6 values
I have the following array of numbers.
Overall, the numbers in the array will always change slightly, however, the only commonality is that the positive numbers will eventually become negative. I would like to build out a function/equation that would only sum the negative numbers of this array, however, I would also want this function to only sum the first 6 negative number.
How can I do this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
