| A | B |
|---|
| COUNT | Counts the number of cells in a range that contain numbers |
| SUMIF | Adds the cells specified by a given condition or criteria |
| CONCAT | Combines a list of range of text strings |
| MID | Returns the characters from the middle of a text string, given a starting position and length |
| FALSE | Returns the logical value FALSE |
| VLOOKUP | 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. By default, the table must be sorted in an ascending order. |
| HLOOKUP | Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify |
| MINUTE | Returns the minute, a number from 0-59 |
| AVERAGE | Returns the average of its arguments, which can be numbers or names, arrays, or references that contain numbers |
| PV | Returns the present value of an investment: the total amount that a series of future payments is worth now |
