SUMIF Formula In Excel
SUMIF function adds all numeric numbers in a given range of cells based on one criteria. Suppose there is name in column A and amount in column B and in column A if a name is repeating more than 1 time and you want to add all the amount It have next to column then Sumif is a best formula to make your work easy. Example as given below.
PARAMETER: =SUMIF ( RANGE, CRITERIA, SUMRANGE )
IMPLEMENT: First select the range column, then select or add a criteria, then select the sum range and its done. Example are provided in image and video.
FORMULA : =SUMIF(A2:A9,C2,B2:B9)