Forum Discussion
How can I use the SUMIF tools if I get an error in the final result
Hi, i need help with this... i think had a mistake cause finally result is $0, someone can explain me what is the error? ... I want to collect the data discriminating according to the selection of...
It looks like the MES column contains the abbreviated month name "ene".
Option 1: change this so that it contains the fill month name "enero"
Option 2: change A2 to "ene" instead of "enero".
Option 3: change the formula to
=SUMAR.SI.CONJUNTO(Registro[MONTO];Registro[MES];IZQUIERDA($A$2;3);Registro[TIPO];"ingreso")
thanks for your help, that was the error HansVogelaar