I am trying to make a linear programming model and I am having an issue with solver. I will attach the file but for my problem there are 5200 square feet of sheet metal available and a maximum and a minimum amount for 4 different products. The amount used has to be between the maximum and minimum but also under the 5200 available combined. Currently solver is making the amount used for each product less than 5200 but I need all of them combined less than 5200 which they are not. I don't know if this isn't possible in excel or if my constraint equations or a setting is incorrect. Any help would be massively appreciated as I've been trying to fix this for ages and I've gotten nowhere. Thanks!
Also to add on to this the issue is happening in the sheet metal box. I will attach another file which highlights the area I am having problems with. Sorry if my working in the main post was a bit confusing