Excel SUMIF Function

Two very useful functions in Excel are the IF Function and the SUM Function:

• The IF function allows you to set conditions that will produce specific results when those conditions are met.
• The SUM function makes it easy to add up data located in rows or columns.

So useful are these two functions, that they have been combined into one - The SUMIF function.

SUMIF will add up values if a certain criterion is met. You get to specify the criterion to be used as well as the data to be summed.

To find out more, read this tutorial on the Excel SUMIF Function.

• Excel SUMIFS Function
• Excel COUNTIF Function
• Excel AVERAGEIFS Function