Advanced IF functions

• • 
  • 3:23
  • Advanced IF functions
• • 
  • 3:31
  • Nested IF functions
• • 
  • 3:35
  • IF with AND and OR
• • 
  • 5:30
  • COUNTIFS and SUMIFS
• • 
  • 4:51
  • AVERAGEIFS and IFERROR

Take this course to learn complex examples and variations of the IF function in Excel, including nested IF functions, IF with AND and OR, COUNTIFS and SUMIFS, and AVERAGEIFS and IFERROR.

Inside this course:

Advanced IF functions (3:23)
Before we get started with advanced IF functions, let's do a quick IF function refresher first. Watch this video for some examples.

Nested IF functions (3:31)
Nested IF functions, meaning one IF function inside of another, allow you to test multiple criteria and increases the number of possible outcomes.

IF with AND and OR (3:35)
Watch this video to see how to extend the functionality of the IF function by nesting AND and OR functions.

COUNTIFS and SUMIFS (5:31)
COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met. SUMIFS adds the cells in a range that meet multiple criteria.

AVERAGEIFS and IFERROR (4:51)
AVERAGEIFS returns the average of all cells that meet multiple criteria. IFERROR returns the value specified if AVERAGEIFS evaluates to an error.

Course summary
A brief reminder of the key points in this course.

More courses available at Microsoft Office Training.