What algorithm to use to solve Quantitative variables in Excel?

[filmch]

Hello,

I am a doctor, I am 61 years old.

What algorithm to use to solve Quantitative variables in Excel?

1. In row 1, the reference values ​​of the norm, i.e. min/max from the norm
2. In row 3, the subtotals. Each person has their own.
3. In column A5 and below. The values ​​​​in the columns are reflected in 100 units, but they can be changed, i.e. you can change 10 units, then divide all the values ​​​​by columns by 10.

Which rows from 1 to 3 (5435 rows in total) are most suitable if the Data by columns are summed up with the values ​​​​in row 3 so that the sum is within the norm of row 1?

Book.xlsx

Sincerely,
Evgeni Mikhailovich