英文:
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, "person", Results!A:A, ">="&DATE(YEAR(TODAY()),7,1), Results!A:A, "<="&DATE(YEAR(TODAY()),7,31),Results!AZ:AZ,"Phone")
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论