Learn it fast with expert-taught software and skills training at lynda.com.

# Article Center

By Curt Frye | Tuesday, February 3, 2015

## Summarize Data with Conditional Functions in Excel

Excel users are often faced with spreadsheets that summarize sales data for multiple areas, such as states within the U.S. or individual countries.

Functions such as SUM or AVERAGE let you summarize your data as a whole—but it can be difficult to find the totals, averages, or counts for subsets of that data. For example, suppose you want to find the total of all sales to Canada. To do that using a standard SUM formula, you would have to identify cells that contain values for all sales to Canada and then create a formula for just those cells.

Fortunately, there’s a set of conditional functions in Excel that let you specify which values should be included in a sum, average, or count calculation. Those functions are: SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, and COUNTIFS.

Here’s how to take advantage of them:

### Get the latest news

•   New course releases
•   Pro tips and tricks

New releases submit clicked

## A lynda.com membership includes:

Certificates of completion
New courses added every week (almost every day!)
Course history to track your progress
Playlists and bookmarks to organize your learning

Thanks for signing up.

We’ll send you a confirmation email shortly.

• new course releases
• general communications
• special notices

Keep up with news, tips, and latest courses with emails from lynda.com.

• new course releases