Lookup
How many rows a block covers
Definition
Counting how many rows sit in a range means giving ROWS that range.
Syntax
=ROWS(array)
Arguments
| Argument | Meaning |
|---|---|
array |
The range whose row count you need, such as D2:D7. |
Worked example
A bin list reserves D2:D7 for six slots. Markers sit at both ends of that range.
| A: Zone | D: Slot |
|---|---|
| Start | 1 |
| Mid | |
| End in D7 | 1 |
Formula: =ROWS(D2:D7)
Result: 6. Rows 2 through 7 are six rows.
Practice
Cells B3 and B10 each hold 1. In C2, write a formula that returns how many rows are in B3:B10.
- In C2, write a ROWS formula for B3:B10.
- C2 should show how many rows are in B3:B10.
Step 1 of 2
Enter =ROWS(B3:B10) in C2.
B3:B10 has 8 rows.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
C2 uses ROWS.
C2 now shows 8.
The next lesson is How many columns a block covers.
Related functions
ROWS is the function that counts the rows in that range.
Common mistake
Using ROW, as in =ROW(D2:D7): ROW then returns only the first row number, 2, instead of the count 6.