INDIRECT: How to Count Non-Empty Cells in Google Sheets

Use INDIRECT to count non-empty cells in Google Sheets. Complete tutorial with syntax and examples.

Syntax

INDIRECT(cell_reference_as_string)

How to Count Non-Empty Cells

Returns the reference specified by a text string. To count non-empty cells, combine INDIRECT with the right arguments for your dataset.

Expert Tips

Useful for dynamic sheet references but can be volatile and slow with large datasets.

Get a Free Quote →