Formula | Description |
---|---|
=SUM(Cell Refernce, Cell Refernce) | It allows you to add two or more numbers together. You can use cell references as well in this formula. |
=COUNT(Cell Refernce:cell Refernce) | The count formula counts the number of cells in a range that have numbers in them. This formula only works with numbers. |
=COUNTA(Cell Refernce:Cell Refernce) | Counts the number of non-empty cells in a range. It will count cells that have numbers and/or any other characters in them. The COUNTA Formula works with all data types. |
=LEN(Cell Refernce) | The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces. |
=TRIM(Cell Refernce) | Gets rid of any space in a cell, except for single spaces between words. |
=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) | Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. |
=IF(logical_statement, return this if logical statement is true, return this if logical statement is false) | Gives the desired intelligence to a program, so that it can take decisions based on a criteria and most importantly decide the program flow. |
=SUMIF(range, criteria, sum_range) | It allows you to add 2 or more numbers together, if condition is satisfied. |