SUMIF function - Microsoft Support For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5 You can use the following formula: =SUMIF (B2:B25,">5") Tips: If you want, you can apply the criteria to one range and sum the corresponding values in a different range