EXCEL：具有多个条件和/或逻辑的COUNTIFS [英] EXCEL: COUNTIFS with multiple criteria and or logic

问题描述

如果单元格的值等于保留，阻止，待处理或存档以及其他多个条件，则尝试对命名范围 STATUS进行计数。

Attempting to count a named range "STATUS" if the value of the cells equals Reserved, Blocked, Pending OR Archive with multiple other countif criteria.

其他所有方法都可以，但是我用于计数状态的数组公式仅在单元格值=保留的情况下才返回计数。

Everything else works, but the array formula I used for counting the status is only returning a count if the cell value = Reserved.

这是我使用的公式：

=（COUNTIFS（DATES，> =& A3，DATES，< & EDATE（A3,1），AGENT， TEST，COMPANY， TEST，STATUS，{ Reserved， Blocked， Pending， Archive}）））

=(COUNTIFS(DATES,">="&A3,DATES,"<"&EDATE(A3,1),AGENT,"TEST",COMPANY,"TEST",STATUS,{"Reserved","Blocked","Pending","Archive"}))

任何帮助将不胜感激。

Any help would be greatly appreciated. Thank you in advance.

推荐答案

我们求和计数

=SUM((COUNTIFS(DATES,">="&A3,DATES,"<"&EDATE(A3,1),AGENT,"TEST",COMPANY,"TEST",STATUS,{"Reserved","Blocked","Pending","Archive"})))

这篇关于EXCEL：具有多个条件和/或逻辑的COUNTIFS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！