How to use Numbers Rows function with Indirect?
I need help with getting row count of a range expressed as text. It is currently returning row count of one instead of 259 = 261 minus 2
iPad mini 6
I don't know what the answer should be when you are asking for the number of rows in a header column with "exclude headers" as the second parameter. I would have guessed it to be all but the header column(s) so I assume this is another bug. ROWS(A,exclude-headers) does give that answer. The answer of "1" is makes no sense.
If you leave off the "exclude headers" parameter, I think you will get the number you expect. Or if you use a column that is not a header column you will get the number you expect. It does not matter which column you use in the function, they all have the same number of rows.
I did notice that there is an inconsistency in how Numbers handles ROWS with "whole column" addressing vs normal addressing, but that isn't the problem here. If row 1 is a header row, column A a header column, and there are 5 rows total, ROWS(A,exclude-headers) is not the same as ROWS(A1:A5, exclude-headers) even though they are referencing the same range.