Excel 2007 SUMIF

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 makes it easier to add up values if a certain criterion is met. The criterion can test the data to be summed or an entirely different range of data.

To find out more, read the short article on the Excel 2007 SUMIF function.

Related Articles

• Excel 2007 IF Function
• Excel 2007 SUM Function
• Excel 2007 SUMIFS Function