VBA-与或的和 [英] VBA - SumIfs with Or

问题描述

我到处都研究了这个问题，但找不到适合自己情况的答案.

I have researched this issue everywhere, and I can't find an answer to my particular situation.

这是我的SumIfs声明.

Here's my SumIfs statement.

B_white = Application.SumIfs(Range("G84:G" & LastRow), Range("G84:G" & LastRow), "1", Range("K84:K" & LastRow), "B*", Range("L84:L" & LastRow), "2 (test)")

对于最终标准，它需要查找"2(测试)"或仅查找"2"，但是我不能使用"2 *"，因为其中将包含"22"和"28"的单元格.

For the final criterion, it needs to look for "2 (test)" OR just "2" but I can't use "2*" because there will be cells with "22" and "28" in them.

如何更改此SumIfs语句，使其查找为"2(测试)"或"2"?

How can I alter this SumIfs statement so that it looks for "2 (test)" or "2"?

推荐答案

B_white = Application.Sum(Application.SumIfs(Range("G84:G" & LastRow), Range("G84:G" & LastRow), "1", Range("K84:K" & LastRow), "B*", Range("L84:L" & LastRow), Array("2 (test)", "2")))

这篇关于VBA-与或的和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！