How To Do SUMIF?

Use `=SUMIF(range, criteria, [sum_range])`

Select the range to evaluate

Enter the condition to match

Optionally select the cells to add

Press Enter

Example: `=SUMIF(A:A, “Apples”, B:B)`

Example: `=SUMIF(A1:A10, “>10”, B1:B10)`

Suggested for You

Trending Today