excel函数简单计算试题(案例)count sum rank
第一题:后面求个数,需要用到count,带条件需要用到if,=COUNTIF(C2:C8,">4000")写完回车即可。
第二题:同上=COUNTIF(C2:C8,"<=4000")
第三题:条件超过2个用ifs,=COUNTIFS(C2:C8,"<=4000",D2:D8,">8000")
第四题:求和用sum,=SUMIF(C2:C8,">4000")
第五题:收入的值为录取人数*学费,=SUMIF(C2:C8,">4000",F2:F8)
第六题:=SUMIFS(F
原创
2020-06-13 10:35:27 ·
1933 阅读 ·
0 评论