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