Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto sum does not consider empty cell
Message
From
29/11/2014 08:12:48
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
28/11/2014 14:11:59
General information
Forum:
Microsoft Office
Category:
Excel
Environment versions
Microsoft Office:
Office 2013
Miscellaneous
Thread ID:
01611531
Message ID:
01611541
Views:
33
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform