SUM Function (Functions in Excel)

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

Related Posts by Categories