Excel Solver is a feature that allows you to find the optimal values for a set of cells, called decision variables, that affect an objective cell, which represents your goal or criterion.

Excel considers blank cells to be 0s so you needn’t fill in these cells with anything to start. Solver will do that for you. In cell C16, sum up the number of items to be bought above as: ...