基于另一列的Excel计数值数量[重复]

This question is an exact duplicate of:

这个问题完全是:

• Count paired instances where their elements are in different columns 1 answer
• 计数成对的实例，其中它们的元素在不同的列1中

I want to count the number of times a value appears based on the criteria in another column. Eg, for the example below I want to search the data and lookup how many times ART has a 2 and a 3, etc. I want to display these results on a separate worksheet

我想根据另一列中的条件计算值出现的次数。例如，对于下面的示例，我想搜索数据并查找有多少次ART有一个2和一个3，等等

Thanks in advance

谢谢提前

1 个解决方案

#1

Use COUNTIFS:

使用条件统计:

=COUNTIFS(C2:C10,"ART",M2:M10,"=2")

The above formula would count the number of times where the class is art and the overall value is 2.

上面的公式将计算类为art并且整体值为2的次数。