ROWS()
Syntax. ROWS(array)
Definition. This function returns the number of rows of an array constant or a cell reference.
Arguments
array (required). An array constant or a reference to a cell range
Background. If you try to use a discontiguous range as the argument, you get the error message, “You’ve entered too many arguments for this function.” If you enclose these arguments in additional parentheses, you will get the #REF! error. If the range is defined by intersections (created by including spaces between the cell references, as in the formula =ROWS(B2:D4 E2:E4) and the intersection is empty, you will get the #NULL! error.
Array constants are numbers or text enclosed in braces. Rows are separated by semicolons, and columns are separated commas. ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.
