Forum Discussion
Solved
Consulta SUMAR SI
Buenos días, quiero usar esta fórmula en la celda =SUMAR.SI(A8:A11;"45*";B8:B11) y me devuelve el valor 0. Los pedidos están en las celdas de A8 a A11 y los importes en B8 a B11. La fórmula en la ...
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.