Excel sheet count rows
Code Example - Excel sheet count rows
=COUNTIF(RANGE, CONDITION)
Example: =COUNTIF(C1:C30, "Paris")
excel rows count
Application.WorksheetFunction.Subtotal(3, Range("A2:A500000"))