From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Tabulating data using multiple criteria

Tabulating data using multiple criteria

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Tabulating data using multiple criteria

“

- In addition to the COUNTIF SUMIF and AVERAGEIF functions there are three additional functions using those same words ending in the letter S. So, COUNTIFS, SUMIFS, AVERAGEIFS. Think of these as allowing multiple criteria rather than a single criterion when searching for summary information. In this list here, it's about 700 rows, we've got these entries off to the right simply to make some of our formulas easier to create. Let's imagine that we would like to know how many of our full time employees have a job rating of five. Now with COUNTIF we can certainly count the number of full time employees, we could count the number of people who have a rating of five. But we can't do both. But we can with COUNTIFS. Again, think of the S as being plural. And we now will enter what are called critera-pair. You don't really see that phrase there, but the first criteria-pair is going to be, we're looking in column F to see who's full time. Now following the comma I could type "Full Time", but…

Contents