In the next example, we have text values in column D and numbers in column E.
Now I can easily change the value in B18 and SUMIF will automatically adjust the criteria and calculate a new result. Notice that I need to enclose the operator in double quotes and use the ampersand to concatenate the reference. You can easily move the criteria out onto the worksheet so that it's easier to change.įor example, I can enter another formula that sums cells greater than 15 by referring to cell B18 with the same logical operator. To sum cells with a value greater than 15, I enter a criteria of " data-type="undefined" target="_blank">15' in double quotes. You can add logical operators to the criteria. If I temporarily enter another 15, that result will change. Excel then returns '30' because two cells in the range contain '15'. There's no need to enter a sum range since we're summing the same cells used in the condition. If you don't supply a sum range, SUMIF will sum the cells in range instead.įor example, if I want to sum the cells in this range that contain the number 15, I enter B7:B12 for the range, and 15 for the criteria. It takes three arguments: range, criteria, and sum range. The SUMIF function sums cells that satisfy a single condition that you supply. In this video we'll look at how to use the SUMIF function to sum cells that meet a single criteria.