SUM Function - Free Excel Practice Online

This free, interactive exercise teaches you SUM Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the SUM Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising SUM Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this SUM Function lesson

1. All functions in Excel start with the = sign. The function inputs, or arguments, go inside the parenthesis and are separated by commas. Type =SUM(E5, F5, G5) into the formula bar to get the sum of iPhone sales for all three years.Copy the resulting sum of iPhone sales into the field below to check your answer.
2. You can also supply a range of cells as the argument to sum. The range E5:E9 tells Excel "Every cell from E5 to E9." Type =SUM(E5:E9) into the formula bar to find total sales for the year 2020.Copy the resulting sum into the field below.
3. Use the SUM function with the argument E6:G6 to get the total Mac sales across the three years. Copy the total amount into the field below.
4. Now you want to calculate the sum of sales for all products across all three years. In the formula bar, use the SUM function with the argument E5:G9. Copy the total sales amount into the field below.
5. Now your boss tells you that 2020 sales were under-reported by $158. Change your formula in the formula bar so that it adds 158 to the total. Your formula should look like this: =SUM(E5:E9, 158). Copy the new total into the field below.
6. Use SUM to find the total sales for 2019 and copy the total into the field below.
7. Use SUM to find the total sales for 2018 and copy the total into the field below.
8. Use SUM to find the total iPad sales across all three years.
9. Use SUM to find the total sales of Wearables, Home and Accessories across the three years.
10. Use SUM to find the total sales of Services across the three years.

SUM Function practice - FAQ