SUMIF function

**SUMIF Syntax:-

=SUMIF(range, criteria, [sum_range]).

** If you use the SUMIF function to sum the values in a range that meets the criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the value that description is “Computer”.You can use following formula:=SUMIF(A1:B7,B9,B2:B7) (B9=Computer)

**If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(A1:B7,Computer,B2:B7) SUM is the only value in the range A1:B7, where the corresponding cells in the range (B1:B7) equal “Computer”.

***Explanation of SUMIF Syntax

** Range: – The Range of cells that you want to be evaluated by criteria in the above example B1:B7selected as a range.Note- Please write the text like this “Computer” Or you can just give a cell reference. like in example B9.

**Criteria:- Criteria in the form of a number, expression, a cell reference, etc. In the above example, ÔÇťComputer” is selected as a criteria.

**Sum_range- The actual cells to add. In the above example, B2:B7 is selected as a Sum range.

Tips

If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, “John”, C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal “John.”

Important: The SUMIF function returns incorrect results when you use it to match strings longer than 255 characters or to the string #VALUE!.

By admin

Leave a Reply

Your email address will not be published.