=OR(COUNTIF(A1:C3,"1")>0,COUNTIF(M1:N8,"1")>0)
公式如下:=IF(COUNTIF(A1:C3,"1")>0,COUNTIF(A1:C3,"1")+COUNTIF(M1:N8,"1"),0)
加不了区域,用两个countif相加不行吗