Lookup & Reference

Excel formula for Count rows or columns in a range

Return how many rows (or columns) a range spans.

Copy this formula

=ROWS(A2:A100)

How the formula works

ROWS counts the rows in a reference and COLUMNS counts the columns — regardless of whether cells are filled. They're useful for building dynamic formulas and checking array sizes.

Examples

=COLUMNS(A1:F1)→6

The range is six columns wide.

FAQ

ROWS vs COUNTA — what's the difference?

ROWS counts the size of the reference; COUNTA counts how many cells actually contain data.

Related formulas

Count blank or non-blank cells Generate a sequence of numbers

Functions used

ROWS COLUMNS COUNTA

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free