更新时间:2022-12-06 22:46:30
使用 = ARRAYFORMULA(len( XXX1:XXX30)> 1)
,然后根据该新列表执行 COUNTIF
: = countif(XXY1: XXY30,true())
。
Create another list using an =ARRAYFORMULA(len(XXX1:XXX30)>1)
and then do a COUNTIF
based on that new list: =countif(XXY1:XXY30,true())
.