completion of steps $9$ & $10.)$

$10.$ Camille also wants to calculate ad amount subtotals for each channel. Convert the table to a

$\frac{4}{8}$

range. Insert a subtotal at each change in the Channel value, using the Sum function to calculate the subtotals. Add subtotals to the Ad Amt values only, and include a summary below the data.

Collapse the outline to display only the subtotals for each channel and the grand total.

$$ Convert a table to a range.

X Insert subtotal in a range.

In the October Ads worksheet, subtotals should be added to the range Al:E$26$ at each change