The formula to use the SUMIF function in Excel is as follows: SUMIF (range, criteria, [sum_range]) Read next: How to use AVERAGEIF and AVERAGEIFS in Excel.

Select OK to use the formula. You’ll receive the formula result in the cell and can review the formula you created in the Formula Bar. There you have it — a basic guide to using Excel as a ...