Question : Count Rows with certain data in Excel
Answered by : shane-eckel
=SUM(--(MMULT(--(ISNUMBER(SEARCH(G4,data))),TRANSPOSE(COLUMN(data)^0))>0))
Source : https://exceljet.net/formula/count-rows-that-contain-specific-values | Last Update : Tue, 19 Jul 22
Question : excel rows count
Answered by : embarrassed-eel-runw6t9n0t0t
Application.WorksheetFunction.Subtotal(3, Range("A2:A500000"))
Source : https://stackoverflow.com/questions/17285897/row-count-on-the-filtered-data | Last Update : Sat, 05 Mar 22