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$.$

Gil the ranse CS:#S vuth the formula in cel as to tofal the Mini ales for Quarter$-$

$2-4.$

C$.$

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