I'm trying to use the fonction "COUNT" for the dashboard lesson (module 3.05)

My problem is that my Excell is in french and I have to find out the way it works compared to what is shown. I.E. in formulas you use coma ( , ), but i have t use semicolon ( ; ) to have my fonction working.

In this particular example for "COUNT", the french equivalent would be "COMPTE", but it's not working. My Excell doesn't find it.

I tried to replace it by "NBVAL" and it worked once with "INDEX" and "OFFSET" BUT !!!

When I try to create my "Dynamique Name Ranges" it worked for the years, it worked for the Acccessories Chart Line, but then, it gives me an error and even if me Dynamic Name formula works, it doesn't want to save the name.

So Where should I look into to resolve that ??

Thanks.