About this lesson
Learn basic math functions including SUM, ROUND and SUBTOTAL.
Multiple versions of this lesson are available, choose the appropriate version for you:
Basic math functions including SUM, ROUND and SUBTOTAL.
When to use
Use to add multiple cells together and return totals and subtotals.
- Create a new worksheet
Ways to use the SUM function
Add up all cells from A1 through A10. (A1 up to A10.)
Add the individual cells separated by the commas. (Just A1 and A10.)
Add A1 plus the range from A5 through A10)
Key points to remember: There is no limit to how many cells or ranges you can add by appending cells or ranges separated by a comma.
The ROUND function
- Takes a number, plus the number of decimals places
- =ROUND(A1,2) Will round the value in A1 to two decimal places
Key points to remember: You should always round multiplication or division in Excel to make sure the value you see in the cell doesn’t have any hidden decimals that will influence your end result.
The SUBTOTAL function
- Has many different “totaling” options, such as SUM, AVERAGE, MIN, etc.
- =SUBTOTAL(9,A1:A10) sums up all numbers in A1:A10, unless they have been included in a previous subtotal.
Hints & tips
In addition to the ones covered here, there are many other math functions available in Excel.Login to download
Lesson notes are only available for subscribers.