Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel IF Function Tutorials

Besides the IF function itself, Excel has a number of functions that combine the IF function with another well used function such as the SUM, AVERAGE, and COUNT functions to create SUMIF, COUNTIF, AVERAGEIF and so on. The tutorials in this section include a step by step example of using the IF function or one of Excel's Something - IF Functions.

## Excel IF Function Step by Step Tutorial

The IF function introduces decision making into a worksheet by allowing you to test to see if a certain condition in a worksheet is true or false and then specifiy different outcomes dependent upon the result. This tutorial includes a step by step example to walk you through using the IF function.

## Excel SUMIF Function Step by Step Tutorial

The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial includes a step by step example of using the SUMIF function in Excel.

## Excel COUNTIF Function Step by Step Tutorial

Excel's COUNTIF function is used to count up the number of times specific data is found in a selected group of cells. This tutorial includes a step by step example of using the COUNTIF function in Excel.

## Excel AVERAGEIF Function Step by Step Tutorial

The AVERAGE IF function finds the average value for a range of cells - but only if those values meet specific criteria. This tutorial includes a step by step example of using Excel's AVERAGE IF function.

## Excel SUMIFS Function Step by Step Tutorial

Excel's SUMIFS function adds up the data in selected cells when specific criteria are met in two or more ranges of data. A step by step example of using the SUMIFS function is included.

## Excel COUNTIFS Function Step by Step Tutorial

Excel's COUNTIFS function is used to count the number of data records in a selected range that meet two or more specified criteria. This tutorial contains a step by step example of using the COUNTIFS function in Excel.

## Excel AVERAGEIFS Function Step by Step Tutorial

The AVERAGEIFS function finds the average value for a range of cells - but only if those values meet the criteria that you set. This tutorial includes a step by step example of using Excel's AVERAGEIFS function.

## Excel SUMIF Function Quick Tutorial

The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIF function in Excel 2010.

## Excel COUNTIF Function Quick Tutorial

Excel's COUNTIF function is used to count up the number of cells in a selected range that meet specified criteria. This tutorial includes a step by step example of using the COUNTIF function in Excel 2010.

## Excel AVERAGEIF Function Quick Tutorial

The AVERAGE IF function is used to find the average of values in cells that meet certain criteria. This tutorial contains a step by step example of using the AVERAGEIF function in Excel.

## Excel SUMIFS Function Quick Tutorial

The SUMIFS function, similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criterion. This article includes an example of using the SUMIFS function in Excel 2010.

## Excel COUNTIFS Function Quick Tutorial

The COUNTIFS function, similar to Excel's COUNTIF function, is used to count up the number of cells in selected ranges that meet multiple criterion. This tutorial contains a step by step example of using COUNTIFS in Excel.

## Excel AVERAGEIFS Quick Tutorial

The AVERAGEIFS function finds the average value for a range of cells - but only if those values meet the criteria that you set. This tutorial includes a step by step example of using Excel's AVERAGEIFS function.

## Excel 2010 IF Function Tutorial

The IF function, one of Excel's logical functions, tests to see if a certain condition in a spreadsheet is true or false. This tutorial includes an example to walk you through using Excel 2010's IF function.