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 SUMMEWENN instead of SUMIF. Click on one of the links below for function translations into your language:

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: =SUMIF(A2:A10,B2)
Comma as decimal separator in your settings: =SUMIF(A2:A10;B2)

Leave a Reply

Your email address will not be published. Required fields are marked *

two + = 9