Stop hunting through cells manually; Excel already knows where your formula broke.
Mastering a few high-impact tools like formatting and tables is the best way to get started in Excel.
If you copy a formula and paste it into the next cell down, Excel shifts that referenced cell, so it will say A2 instead. To prevent shifting, use the dollar sign ($).