问题描述
我正在尝试计算Google电子表格中的列总和DataSheet！G:G =已解决" AND DataSheet！C:C =五月"，它必须计算DataSheet！H:H的总和.
I'm trying to calculate the sum of column in google spreadsheet whenDataSheet!G:G="solved" AND DataSheet!C:C="May" it must calculate the sum of DataSheet!H:H.
我尝试过
=ARRAYFORMULA(SUM(((DataSheet!C:C)="May") * ((DataSheet!G:G)="solved") * (DataSheet!H:H) ))
但是它返回N/A，有人可以帮我吗?
But it returns N/A can anyone help me with this.
推荐答案
如果您的H列上的值为N/A，则此公式将仅返回N/A.你检查了吗?而且，您确定是N/A而不是其他类型的错误吗?
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.
这篇关于Google表格中sumif的多个条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！