我在公式方面遇到了一些问题。在公式中,我尝试根据 C 列中的条件对 E 列中的项目数求和。我使用的公式是,(工作正常。
=SUM(COUNTIFS('Sheet1'!E:E,C86,'Sheet1'!C:C,{"A","B","C","E1","E2","F","G","X","T"}))
但是,在下一个单元格中,我尝试走得更远,并尝试根据 E 列和 C 列中的条件计算 R 列中"是"和"NA"的数量。我使用的公式是——
=SUM(COUNTIFS('Sheet1'!E:E,C86,'Sheet1'!C:C,{"A","B","C","E1","E2","F","G","X","T"},'Sheet1'!R:R,{"Yes","NA"}))
这次公式仅计算 C 列中的"A"和 R 列中的"是"。如果有人能指出我在这个公式上犯了什么错误,那将是非常有帮助的。
提前感谢!
此致敬意
格迈纳克
将'Sheet1'!R:R,{"Yes","NA"}
更改为'Sheet1'!R:R,{"Yes";"NA"}
您只能做两个数组,一个需要垂直;
,另一个需要水平,
:
=SUM(COUNTIFS('Sheet1'!E:E,C86,'Sheet1'!C:C,{"A","B","C","E1","E2","F","G","X","T"},'Sheet1'!R:R,{"Yes";"NA"}))