请教excel中countif函数的格式！

如图，如何写出引号内的条件，即“大于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")