1.SUMIF计算满足条件的数据之和
=SUMIF(统计范围,"条件")
=SUMIF(C2:C25,">0")
2.COUNTIF计算满足条件的元素的个数
=COUNTIF(统计范围,"条件")
=COUNTIF(C2:C25,">0")