Locked lesson.

## About this lesson

Learn basic math functions including SUM, ROUND, and SUBTOTAL.

## Exercise files

Download this lesson’s related exercise files.

Math Functions - Begin.xlsx26.2 KB Math Functions - Complete.xlsx

26.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

#### 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.

Login to downloadLesson notes are only available for subscribers.