You are here

USEFUL_TRICKS OF SUM_FUNCTION

SUM FORMULA():

THIS FORMULA IS USE TO CALCULATE THE SUM OF MORE THAN ONE CELLS VALUE.
EXAMPLE:
A1= 50
A2= 10
A3= 20
A4= 70
A5=(A1:A4) (COLUMN MARK IS USED FOR MAKING A RANGE)
OUTPUT= 150

IN THIS PROCESS AN USER CAN CALCULATE THE SUM IN A RANGE.

STEP_BY_STEP SUM FORMULA_EXCEL (2007)

STEP1

PUT THE VALUES IN THE DIFFERENT CELLS

STEP2

PUT THE FORMULA “=SUM(NAME OF CELL:NAME OF CELL)” {AS MENTIONED ABOVE IN THE EXAMPLE}

STEP 3

PRESS THE “ENTER KEY” AFTER PUTTING THE FORMULA. AND YOU WILL GET THE RESULT

(SUM FUNCTION BY TAKING RANGE IS ONLY USEFUL IN THAT CASE IF AN USER WANT THE TOTAL OF ALL VALUES AT A TIME.)

Leave a Reply

Top