Make a summary in excel sheet for mac3/15/2023 ![]() 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 |