标准范围SUMIFS数组公式 [英] Criteria range in SUMIFS array formula

问题描述

<$p$p><$c$c>=ARRAYFORMULA(IF(ROW(A:A)=1,\"Spend\",SUMIFS(Expenses!G:G,Expenses!D:D,A:A,Expenses!B:B,\"Budget\")))

不产生结果。

如果我改变了标准答：到某一个领域它的工作原理

<$p$p><$c$c>=ARRAYFORMULA(IF(ROW(A:A)=1,\"Spend\",SUMIFS(Expenses!G:G,Expenses!D:D,\"A1\",Expenses!B:B,\"Budget\")))

如果我用简单的SUMIF第一个版本也适用

  = ARRAYFORMULA（IF（ROW（A：A）= 1，花，SUMIF（费用D：！D，A：A，费用G：G）））
 

如何为SUMIFS来不是？

解决方案

难道是ü需要使用SUMPRODUCT（）函数？你可能需要知道您所在的Excel版本。

如果在2007年之前SUMIFS（）将无法工作。

RR

=ARRAYFORMULA(IF(ROW(A:A)=1,"Spend",SUMIFS(Expenses!G:G,Expenses!D:D,A:A,Expenses!B:B,"Budget")))

Doesn't produce a result

If I change the criteria that was "A:A" to a certain field it works

=ARRAYFORMULA(IF(ROW(A:A)=1,"Spend",SUMIFS(Expenses!G:G,Expenses!D:D,"A1",Expenses!B:B,"Budget")))

If I use simple SUMIF the first version also works

=ARRAYFORMULA(IF(ROW(A:A)=1,"Spend",SUMIF(Expenses!D:D,A:A,Expenses!G:G)))

How come not as SUMIFS?

解决方案

could it be u need to use sumproduct() function? you probably need to know which Excel version you are in.

if before 2007 SUMIFS() won't work.

rr

这篇关于标准范围SUMIFS数组公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！