具有多个条件变量的 SUMIFS [英] SUMIFS with multiple criteria variable
本文介绍了具有多个条件变量的 SUMIFS的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我刚刚发现这里我可以使用多个条件的 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屋!
查看全文