Actually you can use this too - COUNTA(A2:A1592), it will tells you right away rows that are "Active" - with a value that isn't blank.