EXCEL关于COUNTIF函数,跪求大神帮助!

2024-12-02 04:08:14
推荐回答(3个)
回答1:

=OR(COUNTIF(A1:C3,"1")>0,COUNTIF(M1:N8,"1")>0)

回答2:

公式如下:
=IF(COUNTIF(A1:C3,"1")>0,COUNTIF(A1:C3,"1")+COUNTIF(M1:N8,"1"),0)

回答3:

加不了区域,用两个countif相加不行吗