1. Benicio wants to compare the sales of each product in 2021 with the sales in 2020. He has the 2020 sales data stored in a separate workbook. Add the 2020 sales data to the All Locations worksheet as follows:
   1. Open the workbook Support_EX19_CS5-8a_2020.xlsx.
   2. Return to the All Locations worksheet in the original workbook.
   3. In cell G5, enter a formula using an external reference to display the total sales of Mini products in 2020 (cell F5).
   4. In the formula in cell G5, change the absolute reference to a mixed reference, with a relative reference to the row number.
   5. Fill the range G6:G8 with the formula in cell G5, filling without formatting.
   6. Close the workbook Support_EX19_CS5-8a_2020.xlsx.

I tried the formula below but its not working

workbook Support_EX19_CS5-8a_2020.xlsx.

55 Xv fx ='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!F$5 A B D E F G G 3 Type Mini $ Voice-activated $ Waterproof $ 3 Total $ Q1 2,366 $ 1,812 $ 1,748 $ 5,926 $ 2021 Sales: All Locations Q2 Q3 Q4 Total 2020 Total 2,374 $ 2,421 $ 2,379 $ 9,540 $ 9,174 1,797 $ 1.844 $ 1,863 7,316 $ 6.043 1,755 $ 1,764 $ 1,797 7,064 $ 6,089 5,926 $ 6,029 $ 6,039 $ 23,920 $ 21,306 o in $000 1 A B C D E F G G 1 2 3 2020 Sales: All Locations 4 Type Q1 Q2 Q3 Q4 Total 5 Mini $ 2,290 $ 2,297 $ 2,298 $ 2,289 $ 9,174 6 voice-activated $ 1,509 $ 1,509 $ 1,514 $ 1,511 $ 6,043 7 Waterproof $ 1,517 $ 1,520 $ 1,524 $ 1,528 $ 6,089 8 Total $ 5,316 $ 5,326 $5,336 $5,328 $21,306 9 10 in $000 55 Xv fx ='[Support_EX19_CS5-8a_2020.xlsx]All Locations'!F$5 A B D E F G G 3 Type Mini $ Voice-activated $ Waterproof $ 3 Total $ Q1 2,366 $ 1,812 $ 1,748 $ 5,926 $ 2021 Sales: All Locations Q2 Q3 Q4 Total 2020 Total 2,374 $ 2,421 $ 2,379 $ 9,540 $ 9,174 1,797 $ 1.844 $ 1,863 7,316 $ 6.043 1,755 $ 1,764 $ 1,797 7,064 $ 6,089 5,926 $ 6,029 $ 6,039 $ 23,920 $ 21,306 o in $000 1 A B C D E F G G 1 2 3 2020 Sales: All Locations 4 Type Q1 Q2 Q3 Q4 Total 5 Mini $ 2,290 $ 2,297 $ 2,298 $ 2,289 $ 9,174 6 voice-activated $ 1,509 $ 1,509 $ 1,514 $ 1,511 $ 6,043 7 Waterproof $ 1,517 $ 1,520 $ 1,524 $ 1,528 $ 6,089 8 Total $ 5,316 $ 5,326 $5,336 $5,328 $21,306 9 10 in $000