Excel subtotal

https://support.office.com/en-au/article/Summing-up-ways-to-add-and-count-Excel-data-d3f918a1-0151-403e-881f-a92f3176f8ea
http://www.gcflearnfree.org/excel2013/20.2

Group sum...

Data => Subtotal