同一行中具有各种“不同于”条件的Google表格中的Countifs增加+1值 [英] Countifs in Google Sheets with various 'different than' criteria in same row adds +1 value
问题描述
我正在尝试计算与通过Google表单提供的Google表格的同一行中某些特定条件不同的所有值,但最终计数显示为 1。
我要从中进行计数的行对应于具有其他选项的多项选择问题,因此用户可以输入其他值,而我试图对该行中其他值的数量。一个B2:B范围(B1是标题),所以我使用了这样的结构:
= COUNTIFS(query(' FORMS RESPONSES'!B2:B,<> TYPE A),
query('FORMS RESPONSES'!B2:B,<> TYPE B),
query(' FORMS RESPONSES'!B2:B,<> TYPE C),
query('FORMS RESPONSES'!B2:B,<> TYPE D),
query('格式响应'!B2:B,<> TYPE E),
)
假设Feed对A,B,C的响应为1,对D,E的响应为无,而其他2个具有随机值的条目,则答案应该为= 2,但它只给了我= 1
我有这个:
= COUNTIFS(
query(datos!B2:B ,<&g t; PC Tipo 1(HP))
,query(datos!B2:B,<> PC Tipo 2(Lenovo))
,query(datos!B2:B, <> PC Tipo 3(Dell))
,query(datos!B2:B,<> Laptop Tipo 1(Lenovo))
,query(datos!B2:B ,<>笔记本电脑Tipo 2(Thinkpad))
,query(datos!B2:B,< Tel Cel。)
)
VG:
B2:B的示例数据条目为:
- PC Tipo 1(HP)
- PC Tipo 2(Lenovo)
- PC Tipo 3(Dell)
- 笔记本电脑Tipo 1(Lenovo)
- 服务器HP
- Projector
因此共有6个条目,其中2个是我要计算的其他类型(服务器HP和投影仪)。结果却使我 = 1
您得到的是 1
作为一个错误。这样做:
= COUNTA(QUERY(datos!B2:B,其中B不含'PC Tipo 1( HP)'
而非B包含'PC Tipo 2(Lenovo)'
而非B包含'PC Tipo 3(Dell)'
而非B包含'Laptop Tipo 1(Lenovo) '
而非B包含'Laptop Tipo 2(Thinkpad)'
而非B包含'Tel Cel。',0))
I'm trying to count all values different than some specific criteria on the same row in a Google sheet that is feed via a google form but the final count shows "1".
The row I'm counting from corresponds to a multiple choice question that has an 'other' option so the user can enter other values and I'm trying to count the number of 'other' values in the row.
I tried normal count and couldif but when you use a <> it ends up counting to infinite if you want to check a B2:B range (B1 Is the heading), so I used a structure of this:
=COUNTIFS(query('FORMS RESPONSES'!B2:B,"<>TYPE A"),
query('FORMS RESPONSES'!B2:B,"<>TYPE B"),
query('FORMS RESPONSES'!B2:B,"<>TYPE C"),
query('FORMS RESPONSES'!B2:B,"<>TYPE D"),
query('FORMS RESPONSES'!B2:B,"<>TYPE E"),
)
Assuming the feed has 1 response for A, B, C, and none for D, E and 2 other entries with random values, the answer should be = 2, yet it gives me only = 1
I have this:
=COUNTIFS(
query(datos!B2:B,"<>PC Tipo 1 (HP)")
,query(datos!B2:B,"<>PC Tipo 2 (Lenovo)")
,query(datos!B2:B,"<>PC Tipo 3 (Dell)")
,query(datos!B2:B,"<>Laptop Tipo 1 (Lenovo)")
,query(datos!B2:B,"<>Laptop Tipo 2 (Thinkpad)")
,query(datos!B2:B,"<>Tel Cel.")
)
VG:
An sample data entry for B2:B would be:
- PC Tipo 1 (HP)
- PC Tipo 2 (Lenovo)
- PC Tipo 3 (Dell)
- Laptop Tipo 1 (Lenovo)
- server HP
- Projector
So there are 6 total entries with 2 being the 'other' kind that I'm trying to count (server HP and Projector). Yet the result gives me =1
you are getting 1
as one error counted. do it like this:
=COUNTA(QUERY(datos!B2:B, "where not B contains 'PC Tipo 1 (HP)'
and not B contains 'PC Tipo 2 (Lenovo)'
and not B contains 'PC Tipo 3 (Dell)'
and not B contains 'Laptop Tipo 1 (Lenovo)'
and not B contains 'Laptop Tipo 2 (Thinkpad)'
and not B contains 'Tel Cel.'", 0))
这篇关于同一行中具有各种“不同于”条件的Google表格中的Countifs增加+1值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!