=COUNTIF(RANGE, CONDITION) Example: =COUNTIF(C1:C30, "Paris")
Get the row count of the ResultSet Move the pointer to the last row and get the row number rs.last(); int rowCount = rs.getRow(); System.out.println(rowCount);
Row number always starts with 1 My last rowNumber is my row count When I move my cursor to the last location to get rowCount