Tag: sum formula in excel

SUMIFS function adds all numeric values in a given range of cells based on more then one criteria. In this function you have to give first sum range ( from which we need to get the total ) then criteria range ( Name column range ) and then criteria1 and then criteria range 2 then criteria 2 (36). Example given in image below. PARAMETER: = SUMIFS ( Sum Range, Criteria Range, Criteria 1, Criteria Range 2, Criteria 2 ) IMPLEMENT: Here the auditor want to know that in this year how many car sold for Maruti Swift and if sold he want a total of the price sold. So the sumifs will take Sum range column (C) and range1 column (A) and 2 criteria 1st (Column D) Criteria range 2 Column (B) and criteria2 Column (E) FORMULA: =SUMIFS(C2:C11,A2:A11,D2,B2:B11,E2)