'Using SumIF for first 6 values

I have the following array of numbers.

enter image description here

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