From the course: Excel Power User Challenge

Unlock this course with a free trial

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

Group and count payments

Group and count payments - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Group and count payments

“

- [Instructor] Let's get into the new GROUPBY function. The challenge is to use it two ways. Look at our data set. We've got a list of divers, the payments that they made toward the fees and a column for who paid the fee. And then use GROUPBY to get a count of payments by diver for amounts that are less than or equal to a thousand dollars. It's that time again, pause the video, get to grouping, get it grouped, come back. (upbeat music) Let's get at it. We are officially a school of groupers. Alright equals GROUPBY double click row fields. We want the diver, comma, we want the values, comma function. We want count and close parenthesis, enter. And I'm going to move this up and glide this scuba diver out of the way. Anson paid his fee in one payment. $3,000. Yep, there's Anson only one time in this date of set. Let's see, Javier in cells G10, G17, and G13. And yep, we see Javier in column G three…

Contents