Forum Discussion
Ximenaxen
Apr 21, 2024Copper Contributor
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
Apr 23, 2024MVP
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#)
Ximenaxen
Apr 25, 2024Copper Contributor
thanks for your help but maybe thats not the problem. In this case the error wasn´t solucionate
- HansVogelaarApr 25, 2024MVP
Can you explain what is wrong with the attached workbook?