Forum Discussion
no funciona fórmula de suma para un rango de datos
The formula in S68 is =SUM(N68:P68) or =N68+O68+P68
The formula in P68 is =L68-M68-N68-O68
So the formula in S68 is equivalent to
=N68+O68+L68-M68-N68-O68
and that is equivalent to
=L68-M68
So S68 depends on L68 and M68, but not on N68 or O68.
Could you attach a small sample workbook without sensitive information? Thanks in advance.
HansVogelaar Thank you!! Here it is, if you change the cells highlighted with yellow, there is no change in the green cell value.
The formula in P68 is
=L68-M68-N68-O68
and that in Q68 is
=SUM(M68:P68)
which is equivalent to
=M68+N68+O68+P68.
So the result is
=M68+N68+O68+L68-M68-N68-O68
and that is equivalent to
=L68
So the value in Q68 is equal to that of L68, and it not dependent on M68, N68 and O68!
HansVogelaar the value that doesn´t change is S68, that cell is dependent on N68, O68 and P68. If I change O68, the value of S68 does not change.
The formula in S68 is =SUM(N68:P68) or =N68+O68+P68
The formula in P68 is =L68-M68-N68-O68
So the formula in S68 is equivalent to
=N68+O68+L68-M68-N68-O68
and that is equivalent to
=L68-M68
So S68 depends on L68 and M68, but not on N68 or O68.