课程: Excel: Advanced Formulas and Functions

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

SUMIFS and COUNTIFS

SUMIFS and COUNTIFS

课程: Excel: Advanced Formulas and Functions

开始一个月试用 购买团队方案

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…

内容