List of Top 10 Basic Excel Formulas & Functions
Basic Excel Formulas List of Top 10 Basic Excel Formulas & Functions Here is the list of Top 10 Basic Formulas & Functions in Excel. SUM COUNT COUNTA COUNTBLANK AVERAGE MIN Excel MAX Excel LEN Excel TRIM Excel IF Excel Now let us discuss each of them in detail – You can download this Basic Formulas Excel Template here – Basic Formulas Excel Template #1 SUM in Excel This Basic Excel Formula is used to get the sum of the value in one or more cells or Range. Example =SUM(A1 :A5 ) Result = 41 (See Image below) #2 COUNT Excel Function This Basic Excel Function is used to Count the numeric value in one or more cells or Range. Example =COUNT(A1:A5) Result = 4 (This will exclude Cell A3 since this formula calculate only Numeric value. See Image below) #3 COUNTA in Excel This formula is used to count the value in one or more cells (This will count the cells irrespective of Number or Text value) Example =COUNTA(A1:A5) Result = 5 (This will Include Cell A3 since this formula calculate