=COUNTIF(L8:L44,">5")我想多个区域一起判断怎么写？

kmcla

and(L8:L44,p8:p44)不行

Excel学徒123

最好上传附件以及模拟下答案

qqyyh

2007版以上用=COUNTIFS(L8:L44,">5",p8:p44,">5")

kmcla

qqyyh 发表于 2017-4-3 11:38
2007版以上用=COUNTIFS(L8:L44,">5",p8:p44,">5")

这样的我知道，看这有点乱。
刚才计算错误
经过仔细观察我改正了错误，乱就乱吧
=J47-((COUNTIF(L8:L44,"<"&((INDIRECT("C"&(INT(ROW()/50)*50+4)))-(INDIRECT("L"&(INT(ROW()/50)*50+4)))))+COUNTIF(L8:L44,">"&((INDIRECT("C"&(INT(ROW()/50)*50+4)))+(INDIRECT("L"&(INT(ROW()/50)*50+4)))))+COUNTIF(P8:P44,"<"&((INDIRECT("C"&(INT(ROW()/50)*50+4)))-(INDIRECT("L"&(INT(ROW()/50)*50+4))))))+COUNTIF(P8:P44,">"&((INDIRECT("C"&(INT(ROW()/50)*50+4)))+(INDIRECT("L"&(INT(ROW()/50)*50+4))))))

kmcla

qqyyh 发表于 2017-4-3 11:38
2007版以上用=COUNTIFS(L8:L44,">5",p8:p44,">5")

其实就是在这两个区域内，找大于2.5和小于1.5的数。各别情况例外