Rows( )

Classic Experience Functions & Formulas
,
1

ROWS()

Description

ROWS returns the number of rows in a given reference. ROWS can useful when you need a number, for example, to do arithmetic.

Syntax

=ROWS(table/filter)

Required

  • Table/filter: A table or filter that returns a list of rows.

Examples

ROWS table image

=ROWS(FILTER(Tasks,"Tasks[Owner]=%","Jorge"))

Returns the number of Jorge’s tasks as 4

=ROWS(FILTER(Tasks,"Tasks[Owner]=%","Nikhil"))

Returns the number of Nikhil’s tasks as 3

=ROWS(FILTER(Tasks,"Tasks[Owner]=%","Jorge"))+Rows(Filter(Tasks,"Tasks[Owner]=%","Nikhil"))

Returns the number 7 which is the sum of Jorge’s tasks (4) and Nikhil’s tasks (3).

Was this article helpful?
  • Yes
  • No

0 voters

2