From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions

Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Create summary statistics using COUNTIFS, SUMIFS, and AVERAGEIFS functions

“

but multiple criteria pair. 1 The first one's going to be, as we've done in the others, 1 status, column C, comma, is full time. 1 I'll pick it out of cell J13 right here. 1 And we're looking for people who have not only 1 that kind of status, but also have a job rating, 1 that's in column H, of five. 1 And continuing with what we did in the previous example, 1 another comma, we're looking at the years of service, 1 comma, for those who have been here more than nine years, 1 double quote, greater than nine, double quote. 1 Enter, we've got our answer there too. 1 So that's the average compensation 1 for people who meet the three criteria. 1 Their status is full time, job rating is five, 1 and they've been here more than nine years. 1 And we'll copy that down the column as well too. 1 And here too, we can copy this downward to see 1 what the actual function is that's being displayed out. 1 So there's a lot of power here with this…

Contents