The NB.SI.ENS (COUNTIFS) function counts the rows that meet several criteria at once, each applying to a range of the same size. It is used to count cases according to combined conditions. It follows the same range-and-criterion pair logic as SOMME.SI.ENS.
Example
=NB.SI.ENS(A2:A100;"Nord";C2:C100;"En retard")