It's a pity that you didn't heed David Tan's advice and didn't give a link to your table - it's really completely unclear from the screenshot where your data starts on the sheet and how far it extends to the right.
Let's say you start your spreadsheet in cell A1 (at least people usually do that). In this case, we see that you have eight A:H columns in red, two I:J columns in yellow, and at least eight K:R columns in green. And you want to use the values of these green columns as the sort criteria.
There are tricky tricks that allow you to process individual rows of a range. However, I do not advise you to look towards
SEQUENCE() and others - formulas using them are difficult to understand, apply and edit. Take it easy - sum the individual columns of the filter range:
Yes, this construction seems clumsy and unwieldy, but you only need to enter it once.