Forum Discussion
Consulta SUMAR SI
- Jan 20, 2021
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.
Ha funcionado! Como no soy una experta me parece difícil de entender esa solución.
Pero ha funcionado.
Muchas gracias Ana.
- SergeiBaklanJan 20, 2021Diamond Contributor
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.
- MirtiJan 20, 2021Copper Contributor
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.
- SergeiBaklanJan 20, 2021Diamond Contributor
Mirti , you are welcome.
You may open the file attached to my post, formulas will be automatically transformed into your locale.
- MirtiJan 20, 2021Copper Contributor