无法生成具有多个条件的COUNTIF。

huangapple go评论94阅读模式
英文:

Unable to generate countif with multiple conditions

问题

=COUNTIFS('Results'!B:B, "person", 'Results'!A:A, ">="&DATE(YEAR(TODAY()),7,1), 'Results'!A:A, "<="&DATE(YEAR(TODAY()),7,31), 'Results'!AZ:AZ, "Phone")

英文:

I'm a little bit stuck at the moment. I have the following formula that works well, but I need to alter it to also check that column AZ includes "Phone".

=COUNTIFS('Results'!B:B, "person", 'Results'!A:A, ">="&DATE(YEAR(TODAY()),7,1), 'Results'!A:A, "<="&DATE(YEAR(TODAY()),7,31))

I've tried adding onto that foruma, using filters and many differnt IF functions but have bit a brick wall. Would appricate any help

答案1

得分: 1

=COUNTIFS(Results!B:B, "person", Results!A:A, ">="&DATE(YEAR(TODAY()),7,1), Results!A:A, "<="&DATE(YEAR(TODAY()),7,31), Results!AZ:AZ, "Phone")

英文:

> I need to alter it to also check that column AZ includes "Phone".

Try this out:

=COUNTIFS(Results!B:B, &quot;person&quot;, Results!A:A, &quot;&gt;=&quot;&amp;DATE(YEAR(TODAY()),7,1), Results!A:A, &quot;&lt;=&quot;&amp;DATE(YEAR(TODAY()),7,31),Results!AZ:AZ,&quot;Phone&quot;)

huangapple
  • 本文由 发表于 2023年7月14日 00:29:30
  • 转载请务必保留本文链接:https://go.coder-hub.com/76681555.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定