In cell B$5,$ enter a formula using the SUM function and $3-$D references that totals the Mini sales values $($cell B$5)$ in Quarter $1$ from the U$.$S$.,$ Canada, and Mexico worksheets.

b$.$

fill the range C$5$:E$5$ with the formula in cell B$5$ to total the Mini sales for Quarter$-$

$2-4.$

C$.$

Fill the range B$6$:E$7$ with the formulas in the range B$5$:E$5$ to total the sales for the other products in Quarters $1-4.$