May 24 2021 05:16 AM
翻译是由机器完成的,作者无法使用以下语言:
在您的消息/图片中,我看不到公式,也看不到它应该实际做什么和不应该做什么。
经您允许,如果我可以推荐的话。 如果您上传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)
May 24 2021 06:19 PM
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.
May 25 2021 12:28 AM
SolutionThat'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)
May 25 2021 12:28 AM
SolutionThat'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)