Formulas and Functions
இந்தக் கட்டுப்பாட்டை மாற்றினால் இந்தப் பக்கம் தானாக மாற்றப்படும்

ROWS

The ROWS function returns the number of rows included in a specified collection of cells.

ROWS(range, headers)

range: A collection of cells. range must contain a reference to a single range of cells, which may contain any values.

headers: An optional modal value specifying whether to include header and footer rows in the count of rows.

include-headers (0 or omitted): Include header and footer rows in the count of rows.

exclude-headers (1): Exclude header and footer rows from the count of rows.

Notes

  • If you select an entire table column for range, ROWS returns the total number of rows in the column, which changes when you resize the table.

Examples

=ROWS(A11:D20) returns 10, the number of rows from 11 to 20.

=ROWS(D) returns the total number of rows in column D.

=ROWS(A1:D5,0) returns 5, the number of rows from 1 to 5, including the header row 1.

=ROWS(A1:D5,1) returns 4, the number of rows from 1 to 5, excluding the header row 1.

See alsoCOLUMNS
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
உதவியாக இருந்ததா?
எழுத்தின் அளவு: 250
அதிகபட்ச எழுத்தின் அளவு: 250
உங்கள் கருத்திற்கு நன்றி.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.