Column E uses the SUBTOTAL function in rows 6, 11 and 12. Columns C and D have SUM functions in rows 6 and 11. The values in columns C, D and E are the same. Since the SUBTOTAL function ignores all other SUBTOTAL functions within its range, it means the grand total formula is much simpler than if you use a SUM function. Any SUBTOTAL functions within these ranges will be ignored. Ref1, Ref2 – range(s) to perform the calculation on. In most cases, 9 or 109 are used as they represent the SUM function in Excel. Syntax: SUBTOTAL(Function _Num, Ref1, )įunction _Num – a number that specifies the function to use in the calculation. Most people use the SUM function when subtotalling, however the grand total calculation can be an issue when rows are inserted within the range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |