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. Click in cell H5 and type =SUM(E5, F5, G5) 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." Click into cell E10 and type =SUM(E5:E9) 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. Click into cell H10 and 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. Double-click cell E10 to modify your formula there 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