Compter avec condition

[barbawawa]

Bonjour à tous,

J'aimerais compter le nb de ID_MSG qui contient le texte "K103", mais je sèche, avez-vous une idée ? je vous mets une capture en PJ .

Par avance merci et bonne journée !!! 

[PrashantSangle]

try

count({<COPRS_MSG_EMIS={"*K103*"}>}ID_MSG)

or

if(wildmatch(COPRS_MSG_EMIS,'*K103*'),count(ID_MSG)

Regards,

Prashant Sangle

[barbawawa]

Hello,

Many thanks for your help, but it doesn't work 😞

[PrashantSangle]

are you getting any error?? can you provide some sample data in excel on which I can try the solution before suggesting any solution.

[barbawawa]

no error, it count, but regardless of the condition. in attachement , the excel file

[PrashantSangle · Accepted solution]

try this

=count(if(WildMatch([Corps du message émis],'*K103*'),[Identifiant Msg]))

Regards,

Prashant Sangle

[barbawawa]

Many many thanks to you, it's working fine !!!

Have a good day

[PrashantSangle]

great. can you like the reply also.