If you have a non-English version of Excel, chances are that all the function names have been translated.
For example, if you use the German version, you have to choose the function SUMMEWENNS instead of SUMIFS, or if you use the Hungarian version, the name of the TEXTJOIN function is SZÖVEGÖSSZEFŰZÉS. If you want to use the function CEILING.MATH in your Finnish version of Excel, you have to type PYÖRISTÄ.KERR.YLÖS.MATEMAATTINEN!
Click on one of the links below for function translations into your language:
Translations of Excel functions into different languages:
- Excel Functions in Catalan
- Excel Functions in Czech
- Excel Functions in Danish
- Excel Functions in Dutch
- Excel Functions in Finnish
- Excel Functions in French
- Excel Functions in Galician
- Excel Functions in German
- Excel Functions in Hungarian
- Excel Functions in Italian
- Excel Functions in Norwegian
- Excel Functions in Polish
- Excel Functions in Portuguese (Brazilian)
- Excel Functions in Portuguese (European)
- Excel Functions in Russian
- Excel Functions in Spanish
- Excel Functions in Swedish
- Excel Functions in Turkish
Important: If your version of Excel uses a comma as a decimal separator, you have to use a semi-colon instead of a comma in the formulas.
Example:
Dot as decimal separator in your settings (3.14): =SUMIF(A2:A10,B2)
Comma as decimal separator in your settings (3,14): =SUMIF(A2:A10;B2)