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?
The risks with inserting columns and rows (and how to spot them)
This is a preview lesson
Purchase this course, or sign in if you’re already enrolled, to take this lesson.