Komt AutoSom vast te zitten op lege cellen? Geen nood! Met een handige truc help je Excel een handje.
Stel je voor dat je in het werkblad Ziektedagen de ziektedagen van je medewerkers wilt optellen. Helaas zijn er in elke rij lege cellen, waardoor AutoSom niet alle cellen automatisch selecteert.
Geen zorgen! Met deze stappen leer je Excel de lege cellen te negeren en toch de correcte totaalbedragen te berekenen.
Stap 1: De formule handmatig invoeren
=SOM(B5:AF5)
.Stap 2: De formule kopiëren met de vulgreep
Nu worden alle ziektedagen, ongeacht de lege cellen, correct opgeteld in kolom AG!
Cookie | Duur | Beschrijving |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |