具有多个条件变量的 SUMIFS [英] SUMIFS with multiple criteria variable

问题描述

我刚刚发现这里我可以使用多个条件的 SUMIFS，这真的很酷.

I just discovered here that I can use SUMIFS with multiple criterias, which is really cool.

但是有什么方法可以将变量设置为标准吗?

But there is any way to set a variable to the criterias?

例子:代替写作

=SUM(SUMIFS(sum_range,criteria_range,{"red","blue"}))

我想将文本红色"放在单元格 A1 上并写下:

I would like to put the text "red" on the cell A1 and write:

=SUM(SUMIFS(sum_range,criteria_range,{A1,"blue"}))

谢谢

推荐答案

如果您的值范围是 A1:A2，请尝试将其用作第三个 (Criteria1) 参数，然后按 CTRL+SHIFT+ENTER 而不是 ENTER.

If your range of values is A1:A2, try using that as the third (Criteria1) argument, and pressing CTRL+SHIFT+ENTER instead of just ENTER.

=SUM(SUMIFS(sum_range,criteria_range,A1:A2))

这将生成一个数组公式，之后您应该会看到括号括起来.

This will produce an array formula and you should see brackets surround the formula afterwards.

{=SUM(SUMIFS(sum_range,criteria_range,A1:A2))}

这篇关于具有多个条件变量的 SUMIFS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！