In this video, I demonstrate four ways of getting your formula to correctly and automatically calculate. The four reasons that they might not be calculating are:
1) Formulas are entered or formatted as text values
2) Calculation mode is set to manual rather than automatic
3) The 'Show formulas' setting has been turned on
4) You have a circular reference