Google电子表格不尊重或不符合条件 [英] Google spreadsheet countifs not respecting or condition

问题描述

我有以下公式:

=COUNTIFS(A2:A41, {"CORE", "TRIAL"})

但是，计数应该为10时为7.有7个核心试验和3个试验.有什么我想念的吗?只是为了测试，我尝试将TRIAL放在第一位，并且算为3

However, the count comes as 7 when it should be 10. There are 7 core and 3 trials. Is there something I am missing? Just for testing, I tried putting TRIAL as first and it counted 3

推荐答案

将公式更改为

=sum(ArrayFormula(COUNTIF(A2:A41, {"CORE", "TRIAL"})))

或使用

=sumproduct(regexmatch(A2:A41, "CORE|TRIAL"))

如果您只需要完全匹配，请使用

If you only want exact matches, use

=sumproduct(regexmatch(A2:A41, "^CORE|TRIAL$"))

看看是否有帮助?

这篇关于Google电子表格不尊重或不符合条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！