You are here

SUMIF EXCEL FORMULAS 2007 WITH EXAMPLE

SUMIF FUNCTION():

THIS FUNCTION IS USE TO CALACULATE SUM OF MORE THAN ONE CELL VALUE USING A CONDITION.

EXAMPLE:
CALCULATE THE SUM OF ALL CELLS WHICH ARE GREATER THAN “50”?
A1=60
A2=70
A3=20
A4=30
A5=90
A6=SUMIF(A1:A5,”>50″)
OUTPUT= 60+70+90= 220

STEP_BY_STEP SUMIF FORMULA_EXCEL(2007):

STEP 1
PUT THE VALUES IN DIFFERENT CELLS

STEP1_SUMIF_EXCEL_FORMULA_2007
STEP1_SUMIF_EXCEL_FORMULA_2007

STEP 2
PUT THE FORMULA “=SUMIF(RANGE,”CRITERIA”)” {AS MENTIONED ABOVE IN THE EXAMPLE}

STEP 2_SUMIF_EXCEL_FORMULA_2007
STEP 2_SUMIF_EXCEL_FORMULA_2007

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

STEP3_SUMIF_EXCEL_FORMULA_2007
STEP3_SUMIF_EXCEL_FORMULA_2007

Leave a Reply

Top