The SUMIF() formula in your file is not quite correct; the third and first arguments should be swapped.
Solver can find an alternative solution with the following configuration.