Excel Tutorial – SUBTOTAL

The SUBTOTAL function in Excel allows you to perform a specific calculation on a range of cells and ignore hidden cells within that range. This can be useful if you have a large dataset that contains hidden rows or columns and you want to perform a calculation on the visible cells only.

To use the SUBTOTAL function, you will need to follow these steps:

1. Select the cell where you want the result of the SUBTOTAL function to appear.
2. Type “=SUBTOTAL(” (without the quotes) into the cell.
3. Specify the type of calculation that you want to perform on the range of cells. There are several options available, including SUM, AVERAGE, COUNT, MAX, MIN, and more. You can find a full list of available calculations in the Excel documentation.
4. Type a comma and then specify the range of cells that you want to perform the calculation on.
5. Close the parenthesis by typing “)”.

For example, if you wanted to calculate the sum of the values in the range A1:A5 and ignore any hidden cells within that range, you could use the following formula: “=SUBTOTAL(9, A1:A5)”. This will return the sum of the visible cells in the range A1:A5.

You can also use the SUBTOTAL function to perform other calculations, such as finding the average, count, maximum, or minimum value in the range. Simply specify the appropriate calculation type in the first parameter of the SUBTOTAL function.

I hope this tutorial has been helpful in understanding how to use the SUBTOTAL function in Excel.