Excel 2003 怎么计算杰出率和及格率

=SUMPRODUCT((A1:I1=60)*(A1:I1=100))/COUNT(A1:I1)

举个例子咯