我有一个包含几列的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公式相当于两个条件
发布评论