Microsoft Excel has numerous functions but the issue is about knowing which function to use in the shortest time We began with a few smart tips in the initial posts which looked aspects like shortcuts and basic functions in at Microsoft Excel 2007. We would continue with the same and gradually address some more text, math and functions related to editing with examples.
Now, to get the sum for the same set of values using Subtotal function, you would have to type the function in the following manner. The format for using the function is =Subtotal(function_num, ref1, [ref2]…). For the above example, the function took the following values= Subtotal(9,b2:b9).
You would find here that the function has an argument- function_num where 9 has been entered. What is 9? Subtotal has pre-defined a set of values for some functions. They are as follows:
So, 9 means sum. In earlier version of MS Excel, one might have had to remember what each value stood for but in Excel 2007, these values appear once the formula name Subtotal is entered.
We would continue bringing out such utility functions to unravel the power of MS Excel.