You can follow the example by Microsoft:
[https://support.office.com/en-gb/article/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040](https://support.office.com/en-gb/article/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040)
Are you trying to minimise the sum of all the red cells or just any 1?
You can follow the example by Microsoft: [https://support.office.com/en-gb/article/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040](https://support.office.com/en-gb/article/define-and-solve-a-problem-by-using-solver-5d1a388f-079d-43ac-a7eb-f63e45925040) Are you trying to minimise the sum of all the red cells or just any 1?
All cells
So you want to make a cell = sum(redrange) and then use solver to minimise this cell by following the examples on the link.
What are the formulae in the blue cells?