This ensures that the same cells are used, even when your spreadsheet changes.
It does this by turning text data, sometimes referred to as atext string, into a cell reference.
This example is based on the data shown in the image above.
Screenshot
The INDIRECT function accepts any text inputs.
A dynamic range can be changed without editing the formula itself.
This eliminates the need to directly edit the formula in cell G1.
Screenshot
The COUNTIF function in this example only counts cellscontaining numbersif they’re larger than 10.
Cells that are blank or contain text data are ignored by the function.
Counting Text With COUNTIF
The COUNTIF function isn’t limited to counting numeric data.
It also counts cells that contain text by checking if they match a certain text.
The COUNTIF function totals the number of cells that have the text valuetwoin them.
In this case, the result is 1.
COUNTBLANK returns an answer of 1 since there is only one blank cell in the range.
Why Use an INDIRECT Function?
The range dynamically shifts inside of the various functions, and the results update accordingly.
This makes overall spreadsheet maintenance much easier, especially for very large spreadsheets.
