Make formulas foolproof from deleted columns
I am trying to make a formula that doesn't break whenever someone deletes a column. Example: We have 5 columns (Group 1, Group 2, Group 3, Group 4, Group 5). I then have a formula in a 6th column which sums the values in the first 5 columns together. But, some projects only have 3 or 4 groups... so the Project Manager wants to delete the extra columns in their project sheet. The problem is, when you do this, the Summation formula breaks and gets a #REF in it which causes the cell to be #Unparseable. I tried using IFERROR and ISERROR but I cannot seem to make this work without having the PM actually edit the formula. Any ideas?