如何让countif函数统计为0的项目不显示

katrina_0622 · 发表于 2023-7-9 23:12

如图中的2345678几个数字统计结果都为0，如何让这些统计结果不显示？

leepoison · 发表于 2023-7-10 08:12

IF(COUNTIF(A1,0)=0,"",COUNTIF(A1,0))

scgaqxg · 发表于 2023-7-10 13:21

本帖最后由 scgaqxg 于 2023-7-10 13:23 编辑

抱歉，我错了。

cbxxgwf · 发表于 2023-7-14 10:56

在countif外面套if

meiya · 发表于 2023-7-15 11:08

J2=IF(COUNTIF(D2:I2,1),COUNTIF(D2:I2,1)&"A+","")&IF(COUNTIF(D2:I2,2),COUNTIF(D2:I2,2)&"A","")&IF(COUNTIF(D2:I2,3),COUNTIF(D2:I2,3)&"B+ ","")&IF(COUNTIF(D2:I2,4),COUNTIF(D2:I2,4)&"B","")&IF(COUNTIF(D2:I2,5),COUNTIF(D2:I2,5)&"C+","")&IF(COUNTIF(D2:I2,6),COUNTIF(D2:I2,6)&"C","")&IF(COUNTIF(D2:I2,7),COUNTIF(D2:I2,7)&"D","")&IF(COUNTIF(D2:I2,8),COUNTIF(D2:I2,8)&"E","")，用这个公式试试，不过这个公式应该可以简化一下，只是暂时没想到

		自动登录	找回密码
密码			免费注册

[求助] 如何让countif函数统计为0的项目不显示