Forum Discussion
Its_Me1010
Jul 01, 2022Copper Contributor
Is it possible ???
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
- OliverScheurichGold Contributor
=SUMPRODUCT((F3:F17="Thomas")*((K3:K17="RDV")+(K3:K17="En")))An alternative could be SUMPRODUCT.
- Its_Me1010Copper ContributorI copied and pasted your formula, it does not work
Does it help if you confirm the formula with Ctrl+Shift+Enter?