Whenever you insert columns or rows, make sure you test the formula using those rows and columns. Has Excel correctly included them in the calculation?
To follow along go to Inserting Columns or Rows HEH
YouTube
Ad Free Version
Available in paid for courses