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.
On the Formulas tab of the ribbon, make sure that Calculation Options is set to Automatic.
En la pestaña Fórmulas de la cinta, asegúrese de que 'Opciones para el cálculo' esté configurado en Automático.
Thank you!! It's set to Automatic, but it still doesn't work.
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.
