“SUM”
Used for – “SUM” Function in MS Excel is used tell MS excel
that a excel has to add up the cell value (if numbers/fraction) / numbers /
fraction or range of cells and display the end result achieved.
Syntax – SUM(Number1, [Number2],…….,[Number255])
or
SUM(Number Range1, [Number Range2],…….,[Number Range255])
Example – Suppose you have to add value
of cell B3 & B7, B3 to B7 and B3 to
B7 with C3 to I3 and result should be displayed in cell A1, C1 and E1
respectively, then you have choice either use “SUM” formula or use “+” formula.
Here we do this by using “SUM”. See example below:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
=SUM(B3,B7)
|
=SUM(B3:B7)
|
=SUM(B3:B7,C3:I3)
|
||||||
2
|
|||||||||
3
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
|
4
|
2
|
||||||||
5
|
3
|
||||||||
6
|
4
|
||||||||
7
|
5
|
||||||||
And
result you get as under:-
A
|
B
|
C
|
D
|
E
|
F
|
G
|
H
|
I
|
|
1
|
6
|
15
|
50
|
||||||
2
|
|||||||||
3
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
|
4
|
2
|
||||||||
5
|
3
|
||||||||
6
|
4
|
||||||||
7
|
5
|
Dear readers, after reading the Content please ask for advice and to provide constructive feedback Please Write Relevant Comment with Polite Language.Your comments inspired me to continue blogging. Your opinion much more valuable to me. Thank you.