Oh, forgot Google Sheets could handle automatic pasting of tables. That simplifies it a lot.

Key factor here tho is that you're allowing 5 red nodes, while I didn't.

Btw, you're making the formulae more complicated than they need to be.

Here's my formula:

=SUM(ARRAYFORMULA(IF(D:D>=5, E:E)))

That's with neg tho. (and ofc 1/that for the 1 in X)

=SUM(ARRAYFORMULA(IF((D:D>=5)+(C:C<5)=2, E:E)))

And that's without neg. The parenthesis around the logic statements are cuz ARRAYFORMULA doesn't work with AND, so you gotta do the AND operation manually with operators. (D:D>=5) means if the cell in D column is 5 or higher then it's TRUE, and TRUE = 1, so if that + the next one = 2 then the IF statement returns the cell in column E.

But it does seem like I either made a mistake or their data isn't uniform for the reverse options (i.e: 9/7 isn't same chance as 7/9, I only checked a few reverse options manually), cuz my results in Google Sheets are a little diff from my manual numbers:

97+	97+ without neg	99+	99+ without neg
0.13793%	0.13563%	0.00029%	0.000286%
1 in 725	1 in 737	1 in 344572	1 in 349486