ROW(A20) vs ROWS($A$1:A20), Which One is Faster?

To get the row number of a cell, is ROW faster or ROWS faster?

For example
ROW(A20) vs ROWS($A$1:A20), which one is faster?

I have hundreds of thousands of formulas containing these (many are inputs for other formulas) and I want to pick the more efficient one.

(Furthermore, how about simply ROW() without parameter on the row where the target cell is located. Is it the fastest?)


Thanks.

These formulas return different results! =ROW(A20) returns the row of the reference. =ROWS(A1:A20) returns the number of rows in the selected range. If I choose =ROW(A2:A20), the formula will return 19.

ROW(A20) and ROWS(A1:A20) both return 20.

I have edited the original post to ROWS($A$1:A20) to avoid confusion.

@Thomas: ROWS($A$1:A20) ... the A1 reference is absolute. So the answer is the same, even when dragged down.

I'd guess that =ROW(A20) would be quicker as the calculation is simpler, but it is just a guess.

Regards, TMS

I vote for =ROW(A20) as well, and use it myself as the prefered numeric incrementer.



But, when in doubt, check it out.

http://www.youtube.com/watch?v=HKbRNqcvhzs

Thanks for the link but the code mentioned is not compatible with Excel x64.