Useful formulas in Excel

SumIf Summarizes the given cells according to the defined condition/logical test.
Vlookup 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.
SubTotal Returns a subtotal in a list or database. (Can take into account hidden rows.)
IfError 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.
If 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.
Indirect 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.