Sort & Filter in challenging excel table, help required

[softkaje]

Good day All,
i have a excel sheet with data as follows:

Name	Amount	Severity-1	Severity-2
Client1	45	4	6
Client2	80	7	8
Client3	65	5	6
Client4	70	4	5
Client5	90	6	9
Client6	35	8	7
Client7	50	6	8
Client8	60	5	7
Client9	20	8	6
Client10	90	7	5

<tbody>
</tbody>

User will input 3 fields, like

Severity-1	>=6
Severity-2	>=8
Amount Cap	150

<tbody>
</tbody>

accordingly sort the columns "severity-1" (ie. >=6) and "severity-2" (ie. >=8), then filter the rows only with the sum of amount cap under 150, like the given below results.


results should be like this.

Name	Amount	Severity-1	Severity-2
Client2	80	7	8
Client7	50	6	8

<tbody>
</tbody>

and it should tell your amount cap is "150", but we are showing less "20".

thanks in advance.