SUM

No Comments

“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








You can check it yourself by copy the highlighted table and pasting in the first cell of the spread sheet.

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.