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
From the course: Excel 2016: Advanced Formulas and Functions
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.