subtotal in excel

SUBTOTAL function: Calculates the sum of the values in a filtered list in Excel.
the function for calculating sums when filtering data is very important for microsoft excel users. this article will summarize how to filter and calculate sums in excel using subtotal.
Excel 2019 (Part 20): Grouping and Subsummary
excel can organize data into groups, allowing you to easily show and hide different parts of a spreadsheet.