sumif的数组参数问题

发布于 2025-02-01 12:01:45 字数 369 浏览 2 评论 0原文

我正在尝试使以下公式起作用，这给了我“对Sumifs的数组论点不同”。

=SUMIFS(ChronologicalExpenditures!I2:I995, ChronologicalExpenditures!N3:N, "*"&H2&"*", ChronologicalExpenditures!B3:B, "Expenditure, Contractor")

基本上，我想在“年代表”中添加值，只有在“年代表”！n3：n“”等于“ ”＆amp; h2＆amp; amp;'“”

因此，基本上是总和（A列），但前提是（B列）=（单元格X的内容）和（C列C）=“示例文本”

谢谢您提供的任何帮助。

原文

I'm trying to make the following formula work and it's giving me "Array arguments to SUMIFS are of different size."

=SUMIFS(ChronologicalExpenditures!I2:I995, ChronologicalExpenditures!N3:N, "*"&H2&"*", ChronologicalExpenditures!B3:B, "Expenditure, Contractor")

Basically, I want to add the values in "ChronologicalExpenditures!I2:I995" together, ONLY if "ChronologicalExpenditures!N3:N" is equal to ""&H2&"" And "ChronologicalExpenditures!B3:B" is equal to "Expenditure, Contractor".

So basically sum (column A) together, but only if (column B) = (Contents of cell X) and (Column C) = "Sample text"

Thank you for any help you can offer.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

⒈起吃苦の倖褔 2025-02-08 12:01:45

尝试：

=SUMIFS(ChronologicalExpenditures!I2:I, 
        ChronologicalExpenditures!N2:N, "*"&H2&"*", 
        ChronologicalExpenditures!B2:B, "Expenditure, Contractor")

try:

=SUMIFS(ChronologicalExpenditures!I2:I, 
        ChronologicalExpenditures!N2:N, "*"&H2&"*", 
        ChronologicalExpenditures!B2:B, "Expenditure, Contractor")

回复收藏 0 原文

~没有更多了~