SOLVED

为何不能计算出结果?

Copper Contributor

各位好,请问:

下图粉红色框内公式是countifs,为何不能计算出结果?是哪里的问题呢?

如使用countif,能计算出结果。

countifs 公式计算不出结果 202105241518.jpg

3 Replies

@Lynn111 

翻译是由机器完成的,作者无法使用以下语言:

 

在您的消息/图片中,我看不到公式,也看不到它应该实际做什么和不应该做什么。

 

经您允许,如果我可以推荐的话。 如果您上传Excel文件(不包含敏感数据),但没有图片,它将为我们所有人提供帮助。 即使说图片可以说一千个单词,但在某些情况下,Excel肯定不是。 这也将对我们所有人都有好处,因为我们可以更好地理解问题,对每个人都是双赢的局面。

 

*了解Excel版本和操作系统也将是一个优势。

 

 

感谢您的理解和耐心

 

 

尼基利诺

 

我知道我什么都不知道(苏格拉底)

------------------------------------------------------------------

In English:

In your message / picture I cannot see the formula, nor what it should actually do and not do.

With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@NikolinoDE 

 

The formula is in the PINK cell,countifs

The output should be 3,But it actually 0.

So i am confused.

 

I am upload a EXCEL file already.Will there have more helpful materials,please let me know.

best response confirmed by Lynn111 (Copper Contributor)
Solution

@Lynn111 

That's since you try to calculate numbers of cells which are at the same time apples AND oranges. There are no such.

For OR condition you may use

=SUM(COUNTIFS( $A$2:$A$5,A2:A3))

or

=COUNTIFS( $A$2:$A$5,A2)+COUNTIFS( $A$2:$A$5,A3)
1 best response

Accepted Solutions
best response confirmed by Lynn111 (Copper Contributor)
Solution

@Lynn111 

That's since you try to calculate numbers of cells which are at the same time apples AND oranges. There are no such.

For OR condition you may use

=SUM(COUNTIFS( $A$2:$A$5,A2:A3))

or

=COUNTIFS( $A$2:$A$5,A2)+COUNTIFS( $A$2:$A$5,A3)

View solution in original post