Insert row/ column causes SUM errors
on channel: AuditExcel Advanced Excel and Financial Model Training and Consulting
00:00 Inserting columns and rows can be risky
00:20 Inserting rows/ columns affect =A1+A2+A3 and =SUM(A1:A3)
01:02 Always use Auditing Toolbar to check after an insert rows/ columns ( • Follow Excel formulas to where they come f... )
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?
On this page of the site you can watch the video online Insert row/ column causes SUM errors with a duration of online in good quality, which was uploaded by the user AuditExcel Advanced Excel and Financial Model Training and Consulting 23 March 2021, share the link with friends and acquaintances, this video has already been watched 1,674 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
