sumif google电子表格的多个标准 [英] Multiple criteria for sumif google spreadsheet

问题描述

我试图计算在
DataSheet！G：G =求解AND DataSheet！C：C =可能时它必须计算DataSheet！H：H的总和。

我已经尝试了

= ARRAYFORMULA（SUM（（（DataSheet！C：C）=May ）*（（DataSheet！G：G）=求解）*（DataSheet！H：H）））

但它返回N / A任何人都可以帮助我 H列的值是 N / A 。你检查过了吗？而且，你确定它是 N / A 而不是其他类型的错误吗？

如果是这样，你能请分享您的电子表格或其样本，以便我可以看看我自己，因为我无法复制此内容。

Im trying to calculate the sum of column in google spreadsheet when DataSheet!G:G="solved" AND DataSheet!C:C="May" it must calculate the sum of DataSheet!H:H.

I have tried

=ARRAYFORMULA(SUM(((DataSheet!C:C)="May") * ((DataSheet!G:G)="solved") * (DataSheet!H:H) ))

But it returns N/A can anyone help me with this.

解决方案

This formula would only returns N/A if a value on your H column is N/A. Have you checked that? And, are you sure it's N/A and not other kind of error?

If so, can you please share your spreadsheet, or a sample of it so I can take a look for myself, because I can't reproduce this.

这篇关于sumif google电子表格的多个标准的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！