Google电子表格COUNTIF公式相当于两个条件 [英] Google Spreadsheet COUNTIF formula equivalent with two criteria

问题描述

我有一个包含几列的Google文档电子表格。在D列我有价值男人或女人。在G栏中，我的值是或否。我想要做的是统计MAN用YES来回答多少次。所以有两个标准1.Man和2.Yes b
$ b

我有这个公式，它只计算单元格D2和G2中的值。我想从D2到D500和从G2到G500的数值。

= IF（AND（'Revision：2'！D2 =Man，'Revision ：2'！G2 =是），1,0）

我该如何做？

谢谢！

解决方案

Google电子表格不支持COUNTIFS功能...但是以下是您可以使用的几个公式之一你想要做什么...

$ $ $ $ $ $ $ $ $ $ $ $ $ $ = $ Array $（Array = ArrayFormula（SUM（（D2：D500 =Man）* G500 =是）））

I have a Google Docs spreadsheet with a few columns. In column D I have values Man OR Woman. In column G I have values Yes OR No. What I would like to to do is to count how many times MAN will answer with YES. So there are two criterias 1.Man and 2.Yes

I have this formula which only counts values in cells D2 and G2. I would like to count values from D2 to D500 and from G2 to G500.

=IF(AND('Revision: 2'!D2="Man",'Revision: 2'!G2="Yes"),1,0)

How I can do that?

Thank you!

解决方案

Google spreadsheet does not support COUNTIFS function ... however following is one of several formulas you can use for what you want to do ...

=ArrayFormula( SUM( ( D2:D500 = "Man" ) * ( G2:G500 = "Yes" ) ) )

这篇关于Google电子表格COUNTIF公式相当于两个条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！