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




I copied and pasted your formula, it does not work


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

@Hans Vogelaar 

Or semicolons instead of commas



An alternative could be SUMPRODUCT.