EXCEL FORMULA's = COUNTIF ( D24:D43 , 3 ) + COUNTIF ( D24:D43 , 4 ) =SUM(Range) =SUM(A1:A10,A35:A50,A95:A100) =Count(A1:A10) it count how many numbers are there? =COUNTIF(A1:A14,"*") it count how many texts are there. =COUNTA(A1:A10) it count how many cells you have filled. =COUNTBLANK(A1:A10) it count only blank cells. =COUNTIF(A1:A100,MLS) =COUNTIF(A1:A100, = Average(A1:A10) =max(A1:A10) =min(A1:A10) =large(A1:A10,2) it will count 2nd highest value =small(A1:A10,2) it will count 2nd smallest value =upper() =lower() =proper() capitalize 1st word =left(A1:A100,4) it will provide you 1st 4 words = right(A1:A100,4) it will provide you 1st 4 words =mid(A,2,3) Covert Numbers into word =Numtoword(column no. e.g. A21) set date format in excel =TODAY() =DAY() =NOW() =MONTH() =YEAR() - Fix the column G4 H4 5 1 ...