Formulas showing #REF! or #VALUE!

This usually means something was typed or pasted over a formula, or a row was deleted.

1. Press Undo (Ctrl+Z or Cmd+Z) if it just happened.
2. Paste values only: use Paste Special, Values, so the colours and formulas stay.
3. Still stuck? Open a fresh BLANK copy from your download and copy your typed numbers across. Or email us and we'll fix it with you.