a$.$ In cell $H4,$ create a formula using the IF function that tests whether the value in the Bundled column $([$@$[$Bundled$?]])$ is "Yes".

b$.$ If the value in the Bundled column is Yes, subtract $10$ from the amount in the Per Month column $([$@$[$Per Month$]]).$

c$.$ Otherwise, the payment is the same as the value in the Per Month column.

d$.$ If necessary, fill the formula to the range $H5$:$H48.$

e$.$ Add a Total Row to the Clients table, which automatically totals the amounts in the Payment column.

f$.$ In cell B$49,$ use the total row to display the count of the clients.