Calculation NB.SI.ENS

Hi,   i'm french so sorry if i'm not really clear in my explanation.   I'm using the following calculation =NB.SI.ENS(B7:B388;"=24";C7:C388;"<31/12/2017")   which mean every number 24 with a d...