## About this lesson

Learn basic math functions including SUM, ROUND and SUBTOTAL.

## Exercise files

Download this lesson’s related exercise files.

Math Functions.xlsx15.3 KB Math Functions - Completed.xlsx

15.6 KB

## Quick reference

### Topic

Math functions.

### Description

Basic math functions including SUM, ROUND and SUBTOTAL.

### Where/when to use the technique

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

Lesson notes are only available for subscribers.