问题描述
我有一个包含几列的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公式相当于两个条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!