Forum Discussion
Solved
为何不能计算出结果？
各位好，请问： 下图粉红色框内公式是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)
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)