From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

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

Tabulating data using a single criterion

Tabulating data using a single criterion

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Tabulating data using a single criterion

- When you're trying to create summary information from large lists, a helpful set of functions includes the COUNTIF SUMIF AVERAGEIF functions. They're related. I'll start with COUNTIF. We're looking at this list here, and the auto questions come up, How many full time people do we have? Now, I got that in the cell to the right, but if I didn't we could still use this function. COUNTIF, to count the number of times that full time appears in, for example, COUNTIF Column F , If I don't have this in a nearby cell to refer to, I can type ""Full Time"" or simply click on cell L2, and complete the entry with control enter, and then double click to get our half-time, contract, and hourly counts as well. COUNTIF, simple, straightforward. Its companion SUMIF and also the companion AVERAGEIF are similar. They're both slightly different than COUNTIF, but more or less begin in the same way. Let's imagine that we want to total the compensation amount for full time people. What is this company…

Contents