a、=sum(d$3:f$3)-(h$3:i$3),b、=sum(d$3:f$3) (h$3:i$3),c、=sum(d3:f3)-(h3:i3),d、=sum(d3:f3) (h3:i3),a、=count(e3:e12,>=0)和=count(e3:e12,=300),b、=count(e3:e12,”>=0”)和=count(e3:e12,”=300”),c、=countif(e3:e12,>=0)和=countif(e3:e12,=300),d、=countif(e3:e12,”=0”)和=countif(e3:e12,”=300”)
考点:office办公软件操作