Go to the Earring worksheet and complete the following steps:
Sort the table by the Material field in ascending order.
Convert table to spreadsheet 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