Excel中要对工作表“成绩表”中的“数学”列(区域D2:D39)统计大于等于60分且小于80分的人数,结果存放到工作表“统计结果”中的B3单元格中,则公式为()。
A. =COUNTIF(成绩表!D2:D39,"">=60AND<80"")
B. =COUNTIF(成绩表!D2:D39,>=60)-COUNTIF(成绩表!D2:D39,>=80)
C. =COUNTIF(成绩表!D2:D39,"">=60"")-COUNTIF(成绩表!D2:D39,"">=80"")
D. =COUNTIF(成绩表!D2:D39,"">=60"")-COUNTIF(成绩表!D2:D39,""<80"")