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. |
Useful formulas in Excel
Updated on June 29, 2023