SUM

Posted on 18-01-2020 , by: admin , in , 0 Comments

SUM

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

Example:

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

Leave a comment