The SUMIF function sums the cells that meet a criterion, and you can use the function to sum cells with the corresponding cells that are a text string in another column.
Example: You are working with a worksheet with the product in column A, the amount in column B, and the profit/loss in column C.
Question: What is the sum of the marks for students with the last name of Williams?
=SUMIF(B2:B10, "Williams", D2:D10)
There are two cells with the word " Williams". Please note that the SUMIF function is not case-sensitive, and "Williams" and "WILLIAMS" are included.
Notes: The SUMIF Function
The SUMIF function sums the values in a range that meets the specified criteria.
Formula:
=SUMIF(range, criterion, [sum_range])
Explanations:
– Range is required; the cells you want to be evaluated by criteria.
– Criterion is required; the criteria define which cells will be added.