Include hidden values When the function_num argument is between 1-11, the SUBTOTAL function will include the hidden values.It is a type of mathematical operation that you like to perform.Ī function_num argument is applied based on the below mentioned two criteria or methods. SUBTOTAL(function_num, ref1, ,…)Whereįunction_num or operation code: It indicates which function should be used to calculate the subtotals within a given list. The formula for the SUBTOTAL function is as follows: It performs a specified calculation for a given set of values. Returns a subtotal in a database or list, i.e., finding out the subtotal of a given range of cells. Excel functions, formula, charts, formatting creating excel dashboard & others
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |