Excel Tricks with Tejraj

In this blog post we will learn to about SUBTOTAL function in excel. SUBTOTAL function will return subtotal from the list or database. Where to find SUBTOTAL function on Excel Screen: SUBTOTAL function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. SUBTOTAL function is highlighted in blue in below image. Once we click on SUBTOTAL option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of SUBTOTAL Function: The Syntax of SUBTOTAL function is as below: =SUBTOTAL(function_num,ref1, ref2, …) Arguments of SUBTOTAL Function: SUBTOTAL function takes arguments as listed below: function_num : In this argument we have to enter 1 to 11. Each number represents different function as listed below: 1: AVERAGE 2: COUNT 3: COUNTA 4: MAX 5: M...

There are almost 400+ functions available in Excel and day by day they are getting updated. These functions are categorized into multiple categories like Logical Functions, Date & Time Functions, Text Functions, Financial Functions, Lookup & Reference Functions and many more. If you master these functions then you will become a master in Excel. In this Blog post we are going to focus only on Basic Excel Functions. These functions are available in Home tab under editing group as shown in below image. These functions are: 1. SUM 2. MAX 3. MIN 4. AVERAGE 5. COUNT Let’s see them one by one. SUM: This function returns the sum of numbers from the selected Cell Range . For example, we have listed few numbers and we will see how to get sum of these numbers using SUM function. To get the sum of these numbers, select the cell which is present below the given numbers, click on “AutoSum” command then click on “Sum” option as shown in below image. You will see SUM function will automaticall...