Excel sheet count rows

                
                        =COUNTIF(RANGE, CONDITION)
Example: =COUNTIF(C1:C30, "Paris")
                    
                

excel rows count

                        
                                Application.WorksheetFunction.Subtotal(3, Range("A2:A500000"))
                            
                        

Related code examples