Please help. Here is full context:
Go to the All Locations worksheet, where Benicio wants to summarize the quarterly and annual totals from the three locations for each type of product. Consolidate the sales data from the three locations as follows:
a. In cell B5, enter a formula using the SUM function and 3-D references that totals the Mini sales values (cell B5) in Quarter 1 from the U.S., Canada, and Mexico worksheets.
b. Fill the range C5:E5 with the formula in cell B5 to total the Mini sales for Quarters 2–4.
c. Fill the range B6:E7 with the formulas in the range B5:E5 to total the sales for the other products in Quarters 1–4.
Reading books is a great way to learn. Here are some of the books we recommend.
a. Enter =sum( then go to U.S. worksheet and select B5, and then type a comma (,), then go to Canada worksheet and select B5, then type a comma (,). Finally, go to the Mexico worksheet and again type B5. The final formula in B5 of All Locations worksheet should be
SUM(U.S.!B5,Canada!B5,Mexico!B5)b. Move your cursor to the end of the left side B5 cell and a + sign will appear. Drag to the left side up to E5.
c. Select B5:E5 and then move your cursor to the left end of the E5 cell. "+" sign will appear. Drag in down upto E7
Here is the video: