FREE EXCEL FILE TO DOWNLOAD: https://jopaexcel.com/excelsubtotal866nxd11qxw

In this Excel video tutorial, we will learn how to do the subtotal function in Excel. The subtotal formula in Excel can replace many important functions in Excel such as the sum, multiplication, count, countif, counta, minimum, maximum, etc. It is an excellent way to perform analyzes in Excel and create reports and dashboards and also use it on a daily basis to automate tasks and automate processes and save time with Excel.

Unlike the main functions in Excel, the subtotal function only performs the operation on visible values, that is, if you filter the data you have in the table, the result is updated to show only the filtered values, the result of the SubTotal formula changes depending on the table filtered with the selected values.

In this practical example of how to use Excel with the subtotal function, I have a sales report or a sales template where I would like to know the total sold, total orders, average margin and total cost. Instead of using the main formulas in Excel such as the sum formula, the count formula, the formula to return the smallest value and the formula to return the largest value in Excel, I will use the subtotal function because this way, whenever I filter the table or organize the In my Excel spreadsheet, the result of the subtotal function will be updated automatically.

#JopaExcel #Dashboard #Excel