INDIRECT Archives | Excel Quick Help

Create a macro in Excel to sum a column

Excel Master 11th March 2023

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.

Excel Advanced

Excel INDIRECT function with INDEX MATCH

Excel Master 23rd August 2022

Worked example on how to use Excel INDIRECT INDEX MATCH combined, including syntax for INDIRECT and INDEX MATCH.

Excel Formula

Excel INDIRECT function

Excel Master 12th August 2022

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.