>When we do an auto sum of a column, if not all the cells are initialized, this will affect the range. Thus, if row 17 is having a value but not row 18 with values in row 19 to 100, this will break the sum of the column as as soon as it sees an empty cell, it breaks the range.
>
>Is there a setting to avoid that?
>
>Basically, we do not want to be forced to enter a zero on cell we do not initialize.
I don't think there is much you can do there - the autosum is is supposed to detect a contiguous range of cells. You can, however, always enter formulae in the old-fashioned way, i.e., manually entering the desired range.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)