From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

SUMIFS and COUNTIFS

SUMIFS and COUNTIFS

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

SUMIFS and COUNTIFS

“

- [Instructor] Let's do some sums and counts based on criteria. Here we are on our overview page where we want to create some summaries. Now let's go over to the donations page. Look, we have a table with donations, the dates, if the payment is a recurring monthly payment, and how it was paid, online, check or cash. Scroll down. There is our data, all of the donations also with the cursor in the table. I'm going to go to table design and you can see the table's name is donations. Okay, let's go back. Overview. In C9, I want to get a count of the cash payments that were greater than are equal to $250. Here we go. Equals COUNTIFS, okay, COUNTIFS, double click that. What is the criteria range? I want to count here. That's the payment method. Comma, what is the criteria? The criteria is cash. And I'm going to hit enter. Now, this is telling me that they were eight cash donations, okay, and we can check…

Contents