|Summarizes the given cells according to the defined condition/logical test.
|You can use Vlookup to search for the first column in an area of cells and then return a value from any column in the same row.
|Returns a subtotal in a list or database. (Can take into account hidden rows.)
|Return a value that you specify, if a formula evaluates to an error. Otherwise it returns the result of the formula. Use the IfError function to catch and handle errors in a formula.
|The If function returns one value if the condition you enter returns TRUE and a different value if the condition return UNTRUE. For example, the formula =IF(A1>10;”Over 10″;”10 or less”) returns “Over 10” if A1 is bigger than 10 and “10 or less” if A1 is smaller than or equal to 10.
|Returns the reference specified in a text string. References are immediately calculated so that the content is shown. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself.