Home / Discussions

Reply to Message

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