Forum Discussion
为何不能计算出结果？
各位好，请问：
下图粉红色框内公式是countifs，为何不能计算出结果？是哪里的问题呢？
如使用countif，能计算出结果。
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)
3 Replies
翻译是由机器完成的，作者无法使用以下语言：
在您的消息/图片中，我看不到公式，也看不到它应该实际做什么和不应该做什么。
经您允许，如果我可以推荐的话。 如果您上传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)
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.
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)
