Important Formulas
=SUM(C1:H1) =MAX(C1:H1) =MIN(C1:H1) =COUNT(C1:H1) =AVERAGE(C1:H1) =ROUND((A1*0.50),0) =AVERAGE(C1:H1) =A1+B1+C1 =A1/6 =A1-H1 =A1*B1 =(A1+B1)*0.50 =RANK(C5,$C$5:$C$10,0) à Descending =RANK(C5,$C$5:$C$10,1) à Ascending =IF(C1>=40,”PASS”,”FAIL”) =IF(MIN(C1:H1)>=40,”PASS”,”FAIL”) =COUNTIF(C1:H1,”>50”) =COUNTIF(C1:H1,”male”) =VLOOKUP(K1,A1:K10,4,0) =SUMIF(A1:C12,B15,C1:C12)