在Excel中计数条件 [英] Count condition in Excel

问题描述

我有很多人被标记为 D ， E ， F 和 NEW 在每种情况下，它们都可能是一个 condition yes 是或 no .

I have a range of people that is labeled as D, E, F, and NEW in each one they could be a condition yes or no.

我正在尝试弄清楚如何计算一个 D 和一个 condition 是

I am trying to figure out how to count someone that is a D and a condition yes

我知道它与 Countif 或 countifs 有关，但不确定如何做到这一点

I know it has to do with Countif or countifs but not sure how to do that

推荐答案

假定值"D"，"E"，"F"，新"位于 A列，并且在 B列中输入是"或否"，您可以使用:

Assuming values 'D', 'E', 'F', 'New' are in column A and condition 'Yes' or 'No' in column B, you would use:

=COUNTIFS($A:$A,"D",$B:$B,"Yes")

这篇关于在Excel中计数条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！