Forum Discussion
Mirti
Jan 20, 2021Copper Contributor
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 ...
- 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.
SergeiBaklan
Jan 20, 2021Diamond Contributor