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