countifs with beetween dates

lecatcharest

Hello,

I don't know what I am doing wrong here. I would like to count the lines that are between 2 dates, that have the name JO and the state of the line is DEMANDE DE PRIX. It's all in french sorry for that hope someone could help me resolve this. Thanks in advance ;)

=COUNTIFS({Suivis de recommandation Plage 1} >= [DATE METRIC]2; {Suivis de recommandation Plage 1} <= [DATE METRIC]3; {suivis de recommandation Plage 8}; =ESTIMATEUR@row; {Suivis de recommandation Plage 6}; "JO")

Paul Newcome

You are missing the semi-colon between the range and criteria for the first two range/criteria sets.

Paul Newcome

You are missing the semi-colon between the range and criteria for the first two range/criteria sets.