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...
HansVogelaar Hi hans, i have a new problem.... the tools SUMIF when i used them on the table the datas was appears disorganized and i don´t know why?cause when I used them in the table previos I used the same tools and the same order and no error came out, can you help me?
I used the tool as follows:
=SUMAR.SI.CONJUNTO(registro[PRESUPUESTO];registro[MES];$B$2;registro[CONCEPTO];N14)
The formula should refer to N16 instead of N14.
You can clear the cells below (O17:O35) and refer to N16#:
=SUMAR.SI.CONJUNTO(registro[PRESUPUESTO];registro[MES];$B$2;registro[CONCEPTO];N16#)
- thanks for your help but maybe thats not the problem. In this case the error wasn´t solucionate
Can you explain what is wrong with the attached workbook?