Saturday, January 22, 2011

Simple Sum Formula

SUM

Horizontal

100

200

300

600

=SUM(C4:E4)

Vertical

100

200

300

600

=SUM(C7:C9)

Single Cells

100

300

600

=SUM(C13,D14,E13)

200

Multiple Ranges

100

400

200

500

3000

600

4800

=SUM(C17:C19,E17:E19)

Functions

100

400

200

500

300

600

800

=SUM(AVERAGE(C23:C25),MAX(E23:E25))

What Does It Do ?

This function creates a total from a list of numbers.

It can be used either horizontally or vertically.

The numbers can be in single cells, ranges are from other functions.

Syntax

=SUM(Range1,Range2,Range3... through to Range30).

Formatting

No special formatting is needed.

Note

Many people use the =SUM() function incorrectly.

This example shows how the SUM has been combined with plus + symbols.

The formula is actually doing more work than needed.

It should have been entered as either =C48+C49+C50 or =SUM(C48:C50).

100

200

300

600

=SUM(C48+C49+C50)

Wrong!

=SUM(C48:C50)

Correct

=C48+C49+C50

Correct

No comments:

Post a Comment

Popular Posts