We now have everything we need to count the number of commissions that are greater than last year’s top commission of $2,710.79. In Excel language, that’s >2,710.79.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Next, let’s group the transactions by customer, then by client, and calculate the total amounts. In cell G1, again, enter the GROUPBY function, specifying B2:C501 (which contains all the customers and ...