Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto sum does not consider empty cell
Message
De
29/11/2014 08:12:48
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
28/11/2014 14:11:59
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Versions des environnements
Microsoft Office:
Office 2013
Divers
Thread ID:
01611531
Message ID:
01611541
Vues:
32
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform