How to activate the automatic calculation in Excel

When Excel does not update the result of a formula after modifying the data, you need to do one of the following ticks:

1) press F9 to refresh the results

2) open File --> Options --> Formulas and go to Calculations and select "Automatic" (Excel 2010)