From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 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

“

- [Instructor] When you work with large lists, sometimes you need to get summary data out of those lists; and certainly one approach, if you're working with this list which is about 750 rows, is to go to the Data tab and work with the subtotal capability. But sometimes it's gonna be more direct to work with actual functions in Excel; and as I scroll to the right in this particular worksheet here, you'll notice over in column N, the functions that I'm about to talk about, a family of functions. And by the way, the last two that you see here are MAXIFS and MINIFS might not be available on your version of Excel. They've been added recently, and you will only see these if you have Office 365 installed and you've installed the latest updates as well. Now, the lower group here all end in the letter S; and we'll get to that momentarily, but let's just start off with the simple use of COUNTIF. We're looking at this data over here to the…

Contents