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:
- Excel Functions in Danish
- Excel Functions in Dutch
- Excel Functions in Finnish
- Excel Functions in French
- Excel Functions in German
- Excel Functions in Hungarian
- Excel Functions in Italian
- Excel Functions in Norwegian
- Excel Functions in Russian
- Excel Functions in Spanish
- Excel Functions in Swedish
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: =SUMIF(A2:A10,B2)
Comma as decimal separator in your settings: =SUMIF(A2:A10;B2)