## About this lesson

Learn basic math functions including SUM, ROUND and SUBTOTAL.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Math Functions.xlsx22.8 KB Math Functions - Completed.xlsx

23.7 KB

## Quick reference

### Math Functions

Basic math functions including SUM, ROUND and SUBTOTAL.

### When to use

Use to add multiple cells together and return totals and subtotals.

### Instructions

Sample data

- Create a new worksheet

Ways to use the SUM function

=SUM(A1:A10) |
Add up all cells from A1 through A10. (A1 up to A10.) |

=SUM(A1,A10) |
Add the individual cells separated by the commas. (Just A1 and A10.) |

=SUM(A1,A5: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.

Lesson notes are only available for subscribers.