Is it possible ???

New Contributor
I've been disappointed for 5 hours and I can't do it... i need your help ! Could someone write me the formula? I don't even know if it's possible.

I need this :
Each time in this data range [F3:F17 ] it is noted "Thomas" and if in this data range [K3:K17] it is noted "RDV" or "En" then you must add +1 in this box

if you succeed, ty :)

 

5 Replies

@Its_Me1010 

Try

=SUM(COUNTIFS(F3:F17,"Thomas",K3:K17,{"RDV","En"}))

I copied and pasted your formula, it does not work

@Its_Me1010 

Does it help if you confirm the formula with Ctrl+Shift+Enter?

@Hans Vogelaar 

Or semicolons instead of commas

@Its_Me1010 

=SUMPRODUCT((F3:F17="Thomas")*((K3:K17="RDV")+(K3:K17="En")))

An alternative could be SUMPRODUCT.

sumproduct.JPG