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 create and use Excel Lambda functions in Excel 365
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 return an array of non-adjacent cells in Excel.
How to use the VLOOKUP function in Excel
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation