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) set date format in excel =TODAY() =DAY() =NOW() =MONTH() =YEAR() - Fix the column G4 H4 5 1 = 6 (=G4+H4) 2 = 7 (=$G$4+H4) - Provide the color to specific text press ctrl +1 it open conditional formatting custom enter following command [>0]#;[Red](-0) [