## 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.xlsx15.7 KB Math Functions - Completed.xlsx

16.1 KB

## Quick reference

### Topic

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.

*Note: In addition to the ones covered here, there are many other math functions available in Excel.*

Lesson notes are only available for subscribers.