Jul 01 2022 05:41 AM
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 :)
Jul 01 2022 05:57 AM
Jul 01 2022 07:26 AM
Does it help if you confirm the formula with Ctrl+Shift+Enter?
Jul 02 2022 05:05 AM
=SUMPRODUCT((F3:F17="Thomas")*((K3:K17="RDV")+(K3:K17="En")))
An alternative could be SUMPRODUCT.