Excel in Other Languages

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:

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.

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)