How to create a macro in Excel in 3 easy steps. The macro sums a column of values which can be set dynamically by referring to range using the INDIRECT() function. This method also shows how to use a dynamic formula which reads a value from the cell above the current cell.
Worked example on how to use Excel INDIRECT INDEX MATCH combined, including syntax for INDIRECT and INDEX MATCH.
How to use Excel’s INDIRECT function to refer to cells using the values entered into another cell. We show the basic method of how it works, and a more advanced example to refer to content in other worksheets.
How to create and use Excel Lambda functions in Excel 365
How to write an IF statement in Excel, and nest IF statements to test for multiple conditions. Key tips and rules about IFs and nested IFs in Excel.
Excel’s IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message. Examples with syntax showing IFERROR then blank, IFERROR with VLOOKUP, IFERROR then perform another function.
How to find errors in a complex formula, step by step, using Excel’s EVALUATE FORMULA function. Where to find the command, method, worked example, and related topics.
In this detailed worked example, we show step by step how to retrieve a dynamic array of values, using a range of Excel’s functions including OFFSET, INDEX MATCH, INDIRECT, and ADDRESS.
How to fix Excel when formulas are not automatically calculating and flash fill doesn’t fill the formula down the column.
Sum the current value and all those that precede it in a column. This topic also shows how to fill cells down a column.
