Excel like a finance pro.
← The libraryPractice · 2 questions →
Lookup function
ROWS
Returns the number of rows in a range.
CommonDifficulty 1050 · CapableUsage rank #90 of 520
When to use it
How many rows a range has. Sizes, last-row logic, and running counts in copy-down formulas.
The shape of it
- Syntax
=ROWS(array)
Worked examples
Range height
=ROWS(A2:A10) → 9
Nine rows.
Table records
=ROWS(Table1) → 250
The record count of a Table.
Cell count
=ROWS(A2:A10)*COLUMNS(A2:C10) → 27
Total cells in a block.
Worth knowing
- Running counter that survives deletions: =ROWS($A$2:A2).
- Last value of a range: =INDEX(range,ROWS(range)).
- COUNTA counts filled cells; ROWS counts the range whether filled or not.
Where it goes wrong
- Returns the size of the range, not the number of non-empty cells.
- A whole-column reference returns 1,048,576.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.