Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Описание: Download Excel Start File: https://people.highline.edu/mgirvin/Y...

Download Excel File: http://people.highline.edu/mgirvin/Ex...
See 6 methods to add all the subtotals in a column:
1. Manually with the SUM function
2. SUM function divided by 2 SUM/2
3. Array Formulas that uses SUMPRODUCT and the New Excel 2013 function ISFORMULA
4. SUBTOTAL if subtotals were created with SUBTOTAL function
5. AGGREGATE if subtotals were created with SUBTOTAL function
6. Subtotal feature