Forum Discussion
Solved
no funciona fórmula de suma para un rango de datos
cuando realizo una suma de un rango de datos y modifico alguno de estos datos, no se cambia el resultado. Está en cálculo automático y las celdas tienen formato numérico.
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.
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.
- Ohhh of course!! Sorry!!! Thank you!! I got it!!!