excel count rows in datatable code example

Example 1: datatable count number of rows

var table = $('#example').DataTable();
table.rows().count();

Example 2: Excel sheet count rows

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