问题描述: EXCEL函数问题:我现在需要用函数计算出G和H的数值,应该怎么算呢? 1个回答 分类:综合 2014-10-13 问题解答: 我来补答 G列的公式:=COUNTIF(E:E,">=400")-COUNTIF(E:E,">499")H列的公式:=COUNTIF(E:E,">=500")-COUNTIF(E:E,">599")I列的公式:=COUNTIF(E:E,">=600") 展开全文阅读