Go to the Earring worksheet and complete the following steps: Sort the table by the Material field in ascending order. Convert the table to a normal range. Insert subtotals into the range A2:G25, with the subtotals appearing at each change in the Material column value. The subtotals should use the SUM function and include subtotals for the 2018, 2019, and 2020 fields. (Hint: Make sure to check the summary below data check box if it is not checked automatically.)
Solved by I. J. in 25 mins