From the course: Excel: Advanced Formulas and Functions

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

SUMIFS and COUNTIFS

SUMIFS and COUNTIFS - Microsoft Excel Tutorial

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're 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. Let's go back. Overview. In C9, I want to get a count of the cash payments that were greater than or 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 there were eight cash donations, okay, and we can check that.…

Contents