My god the problem was so banal it is stupid.
Apparently in my Excel version (seemingly 2021) the criteria are divided by semicolons in the syntax.........
It is working now. Thanks for your effort though