Forum Discussion
Consulta SUMAR SI
Most probably you have numbers, not texts in left column. When second formula, please check attached file.
As a comment, it's much better to share sample file instead of screenshot.
Most probably you have numbers, not texts in left column. When second formula, please check attached file.
As a comment, it's much better to share sample file instead of screenshot.
Ya me ha salido. En español, en las funciones se separan las condiciones con ; en lugar de ,
En la parte de la Función IZQUIERDA(A6:A9;2)
Muchas gracias Sergei.
Mirti , you are welcome.
You may open the file attached to my post, formulas will be automatically transformed into your locale.
I have opened the file and formulas haven´t been transformed in spanish.
Do you mean the formula which you see in formula bar? If your Excel is on Spanish formula shall be shown for Spanish locale. And you always may use this tool Translator • Excel-Translator (excel-translator.de)