Use Sum(a1:a3) instead of a1+a2+a3 | Message 39 of 81 | TechRepublic

Discussion on:

10 ways to screw up your spreadsheet design

View entire thread

Message 39 of 81

Next » « Prev

1 Vote

+ -

Use Sum(a1:a3) instead of a1+a2+a3

I think this is a classic that was not mentioned. You can easily add a column in the middle and forget to change the formula. It will still LOOK OK. I made a BIG mistake accepting a spreadsheet set up that way.

Posted by jdishun

27th Jun 2011