In Example $1\mathrm{.}3,$ the range E$9$:E$11$ does not have a range name. Open your completed Excel file and name this range Costs. Then look at the formula in cell E$12.$ It does not automatically use the new range name. Modify the formula so that it does. Then select cell G$4$ and paste the new list of range names over the previous list.