If you have a spreadsheet containing a list of products and sales figures, or employees and their salaries, you may find the Subtotal function very useful.  This video also shows how to use the basic "Filter" function.  You will use the "Filter" function to sort your spreadsheet before using "Subtotal".