Excel pivot tables will summarise a list/table of data very easily.
A video is available on the IT Services Study Direct Site, Using Recommended Pivot Tables
With the cursor in the table of data from the Insert table select Recommended Pivot tables and choose one of the suggested tables.
Please suggest an improvement
(login needed, link opens in new window)
Your views are welcome and will help other readers of this page.