countifs多条件排序
In Excel 2007 and Excel 2010, you can use the new COUNTIFS function to count, based on multiple criteria.
在Excel 2007和Excel 2010中,可以基于多个条件使用新的COUNTIFS函数进行计数。
For example, in a list of orders, you can find out how many orders were for pens, and had a quantity of 10 or more.
例如,在订单列表中,您可以找到笔的订单数量,数量为10个或更多。
I have updated the Contextures COUNT Functions page, to include a COUNTIFS example, and video demo.
我已经更新了Contextures COUNT Functions页面,以包括COUNTIFS示例和视频演示。
If you are using Excel 2003, or earlier versions, you can use the SUMPRODUCT function instead. There is an example for that function on the COUNT page too.
如果使用的是Excel 2003或更早版本,则可以改用SUMPRODUCT函数。 COUNT页上也有该功能的示例。
观看COUNTIFS视频 (Watch the COUNTIFS Video)
To see the steps for using the COUNTIFS function, you can watch this short Excel video tutorial.
要查看使用COUNTIFS函数的步骤,您可以观看这段简短的Excel视频教程。
翻译自: https://contexturesblog.com/archives/2012/01/31/use-excel-countifs-to-count-with-multiple-criteria/
countifs多条件排序