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)

• Share on Facebook
• Share on Twitter
• Share on Pinterest
• Share on LinkedIn
• Share via Email
• Share on Tumblr
• Share on Reddit