=COUNTIFS(B2:B15,F2,C2:C15,E2,A2:A15,">G2“,A2:A15,"<H2”) 按Enter键确认,发现一个怪事儿:明明肉眼可见有符合条件的,结果却显示为0,如下图: =COUNTIFS(B2:B15,F2,C2:C15,E2,A2:A15,">"&G2,A2:A15,"<"&H2) 按Enter键确认,即可得到正确结果,如下图: |
|
来自: bitterfleabane > 《待分类》