如圖，如何寫出引號內的條件，即“大于60小于90”用符合excel語法要求的方式寫！[

熱心網友

=countif(c4:c34,and(c460,c4<90))

熱心網友

同意jscpj的數組公式iask0 的公式 =COUNTIF(C4:C34,"60")-COUNTIF(C4:C34,"=90") 計算時會出錯，要改為=COUNTIF(C4:C34,"60")-COUNTIF(C4:C34,"<90")+countif(c4:c34,"<60")

熱心網友

=SUM((C4:C3460)*(C4:C34<90))這是個數組公式，輸入上述公式，按Ctrl+Shift+Enter鍵。

熱心網友

=COUNTIF(C4:C34,"60")-COUNTIF(C4:C34,"=90")