COUNTIF公式459364199 2 5 COUNTIF(B1:K1,">4")194290508 1 0 COUNTIF(B2:K2,">4")结果错误 不是0068783149 0 0 COUNTIF(B3:K3,">4")结果错误 不是0555132403 1 0 COUNTIF(B4:K4,">4")结果错误 不是0304877339 5 0 COUNTIF(B5:K5,">4")结果错误
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/05 02:05:01
![COUNTIF公式459364199 2 5 COUNTIF(B1:K1,](/uploads/image/z/7100108-44-8.jpg?t=COUNTIF%E5%85%AC%E5%BC%8F459364199+2+5+COUNTIF%28B1%3AK1%2C%22%3E4%22%29194290508+1+0+COUNTIF%28B2%3AK2%2C%22%3E4%22%29%E7%BB%93%E6%9E%9C%E9%94%99%E8%AF%AF+%E4%B8%8D%E6%98%AF0068783149+0+0+COUNTIF%28B3%3AK3%2C%22%3E4%22%29%E7%BB%93%E6%9E%9C%E9%94%99%E8%AF%AF+%E4%B8%8D%E6%98%AF0555132403+1+0+COUNTIF%28B4%3AK4%2C%22%3E4%22%29%E7%BB%93%E6%9E%9C%E9%94%99%E8%AF%AF+%E4%B8%8D%E6%98%AF0304877339+5+0+COUNTIF%28B5%3AK5%2C%22%3E4%22%29%E7%BB%93%E6%9E%9C%E9%94%99%E8%AF%AF)
COUNTIF公式459364199 2 5 COUNTIF(B1:K1,">4")194290508 1 0 COUNTIF(B2:K2,">4")结果错误 不是0068783149 0 0 COUNTIF(B3:K3,">4")结果错误 不是0555132403 1 0 COUNTIF(B4:K4,">4")结果错误 不是0304877339 5 0 COUNTIF(B5:K5,">4")结果错误
COUNTIF公式
459364199 2 5 COUNTIF(B1:K1,">4")
194290508 1 0 COUNTIF(B2:K2,">4")结果错误 不是0
068783149 0 0 COUNTIF(B3:K3,">4")结果错误 不是0
555132403 1 0 COUNTIF(B4:K4,">4")结果错误 不是0
304877339 5 0 COUNTIF(B5:K5,">4")结果错误 不是0
COUNTIF公式459364199 2 5 COUNTIF(B1:K1,">4")194290508 1 0 COUNTIF(B2:K2,">4")结果错误 不是0068783149 0 0 COUNTIF(B3:K3,">4")结果错误 不是0555132403 1 0 COUNTIF(B4:K4,">4")结果错误 不是0304877339 5 0 COUNTIF(B5:K5,">4")结果错误
结果当然会错误,你的‘194290508 1’里面‘9 9 5 9’这些不都>4吗?所以结果是4不是0.
而068783149 0里面也有‘6 8 7 8 9’>4所以结果等于5不等于0.
068783149 0结果等于5
555132403 1结果等于3
304877339 5结果等于4
我知道你的0是代表的意思,只想问你是不是用错公式了.