Name

ROWS

Synopsis

Use ROWS to determine the number of rows in the specified array.

To Calculate

=ROWS(Array)

Example

Figure 16-5 illustrates how ROWS is used to figure out the number of columns in the specified array. In this example the function is used to determine the number of sales periods (months) in the array.

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.