There are 3 "all day Saturday packages" at different values based on the number of people registering.
The 'Anne' tab has the list created for the lookup values. Name of Range is "Package".
(X) Column - a choice of 1, 2, or 3 - with value of 1 added to Bkfst (Z), Lunch (AB), Wksps(AD),and Banquet (AH)
(Y) Column is for the price of the package.
For those who do not want a 'package' deal and want to pick and choose: require a formula to calculate on the values in the following columns:
Z, AB, AC, AD, AE, AF, AH, AI with the subtotal in column AK. Row 5 has the prices for each of the columns.