You are here

USEFUL_TRICKS_OF_SUM_FORMULA_(2) EXCEL 2007

SUM FUNCTION():

THIS FUNCTION IS USE TO CALCULATE THE SUM OF PARTICULAR CELL VALUES AS PER THE REQUIREMENT.

EXAMPLE:

Q. CALCULATE THE SUM OF A1,A3,A5 & A6 CELL?

A1=20
A2=30
A3=50
A4=60
A5=70
A6=90
A7=SUM(A1,A3,A5,A6)
OR
A7=A1+A3+A5+A6

THIS PROCESS IS USED IN THAT CASE IF AN USER WANT THE SUM OF PARTICULAR CELLS.

STEP BY STEPĀ  SUM FUNCTION MS EXCEL:

STEP1
PUT THE NUMBERS IN DIFFERENT CELLS

STEP2
THEN PUT THE FORMULA =SUM(CELL NUM,CELL NUM,CELL NUM)

STEP3
THEN PRESS THE ENTER KEY

OR

STEP BY STEP SUM PROCESS IN MS EXCEL WITHOUT USING THE SUM FORMULA:

THE USER CAN ALSO CALCULATE THE SUM OF DIFFERENT CELLS WITHOUT THE SUM FUNCTION.

STEP 1
PUT THE NUMBERS IN DIFFERENT CELLS

STEP2
THEN PUT THE FORMULA =CELL NUM+CELL NUM+CELL NUM\

STEP 3
PRESS THE ENTER KEY

Leave a Reply

Top