ROWS
Returns the number of rows in a given reference.
Syntax:
ROWS(reference)
reference may be given explicitly (eg A3:B5)
Example:
ROWS(A3:B5)
returns 3; there are three rows in this range, namely rows 3,4 and 5.
ROWS(G4:G6)
returns 3; there are three rows in this range, namely rows 4,5 and 6.
ROWS(D8)
returns 1; D8 is interpreted as a one cell range, with a single row (row 8).
Application:
Imagine you're a teacher and you've created a spreadsheet to keep track of your students' grades for a project. You want to quickly see how many students are in the class.
Spreadsheet Table: Project Grades
Student Name | Project A | Project B | Project C | ||
|---|---|---|---|---|---|
A | B | C | D | ||
1 | Alice Smith | 85 | 92 | 88 | |
2 | Bob Johnson | 78 | 85 | 80 | |
3 | Charlie Green | 95 | 90 | 96 | |
4 | David Williams | 65 | 70 | 72 | |
5 | Eva Davis | 91 | 94 | 90 |
To find the number of students, you can use the ROWS function.
Example Usage:
Let's say the student names are in the range of cells from A1 to A5.
You would type the following formula into an empty cell:
ROWS(A1:A5)
Result:
The function will return the number 5, because there are 5 rows in the specified range (A1, A2, A3, A4, and A5), which corresponds to the 5 students in the class.
Result:
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof