Data -> Outline-> Subtotal Hello Subtotals! 3. What Do You See? This spreadsheet now has Subtotals that count the number of customers in each city. There is also a Grand Total that adds up all of our customers in all of the cities.   What Else Do You See? Microsoft Excel created formulas for the Subtotals. Scroll down and select any Subtotal. Please review the formula. This example shows: =SUBTOTAL(3,F2:F245)   Impressive.   Keep going... Exam 77-888: Microsoft Excel Expert 2010 3. Presenting Data Visually 3.2. Apply data analysis: Subtotal