巴山渝人 发表于 2021-12-2 08:59:00

从序号范围及水果种类名称个数问题

工作表 SHEET2 , 黄色就是统计个数结果

王二斤 发表于 2021-12-5 04:40:36

B2=SUM(COUNTIFS(Sheet1!$B:$B,$A2,Sheet1!$A:$A,">="&MID(SUBSTITUTE(B$1,"~",REPT(" ",9)),{1,10},9)+{0,1})*{1,-1})
右拉下拉

柳絮榆钱 发表于 2021-12-10 15:41:07

=MMULT(COUNTIFS(Sheet1!$A:$A,{">=",">"}&IMREAL(IMDIV(SUBSTITUTE(B1,"~","+")&"i",{1,"i"})),Sheet1!$B:$B,$A2),{1;-1})

右拉下拉

艾桐 发表于 2022-1-6 00:40:59

数据透视表，对序号进行手动分组：

骑扬来财 发表于 2022-1-15 22:32:27

多谢两位大佬,您们太牛了,问题总算解决了

韶华不负 发表于 2022-2-1 10:16:31

=COUNT(TEXT(Sheet1!$A$2:$A$48,SUBSTITUTE("[<"&B$1&"];〇","~","]〇;[<="))/(Sheet1!$B$2:$B$48=$A2))

换个套路，右拉下拉

新时代的中年人 发表于 2022-2-4 15:33:03

=COUNTIFS(Sheet1!$B:$B,$A2,Sheet1!$A:$A,">="&LEFT(B$1),Sheet1!$A:$A,"<="&-LOOKUP(,-RIGHT(B$1,{1,2})))

不明所以丢了个账号 发表于 2022-2-15 16:03:29

SHEET2 , B2:F2
=TRANSPOSE(FREQUENCY(IF(Sheet1!$B$2:$B$48=$A2,--Sheet1!$A$2:$A$48),{2,4,6,8,11}))
页: [1]
查看完整版本: 从序号范围及水果种类名称个数问题