表格内有600-800范围的数共100个,,要求出在范围650-750 的数的个数怎么做?
如果是wps呢?数字在a1:j10,还有能把>=650与<=750写在一起吗
=COUNTIF(A1:J10,">=650")-COUNTIF(A1:J10,">750")=COUNTIFS(A1:J10,">=650",A1:J10,"=650与="&A2)-COUNTIF(A1:J10,">"&B2)=COUNTIFS(A1:J10,">="&A2",A1:J10,"<="&B2)