Abstract

Transcript

TheSUM functionis a simple function that adds up numbers.

Let’s take a look.

The SUM function sums numeric values.

SUM simply ignores blank cells.

The formula =SUM(D7:E9) will return “1,350”.

Like blanks, SUM ignores text values.

In addition to ranges, SUM can work with individual cells, too.

Just separate each additional item with a comma.

As you enter these values in, you’re free to combine both ranges and individual cell references.

This is a good way to fix a mistake.