Where there is more than one student enrolled, customers are given a 5% sibling discount. This is applied to the fees up front but as part of the report you are required to calculate what this amount was.

Where there is more than one student enrolled, customers are given a 5% sibling discount. This is applied to the fees up front but as part of the report you are required to calculate what this amount was. The calculation has already been done in column P, but it has been calculated for everyone. Change the calculation so it looks up the enrolments for the customer in the SYS DATA sheet and only calculates the Sibling Discount if the number of enrolments is two or more. (If no siblings return 0.) Include an Average for Sibling Discount in the Total row. What is the average sibling discount?