Excel SUMIF Function

Two of the most useful functions available in Excel are the IF Function and the SUM Function:

• The IF function introduces decision making which adds flexibility to your to spreadsheets.
• 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 and also the data to be summed.

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

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