{"id":1736,"date":"2023-11-08T20:34:39","date_gmt":"2023-11-08T20:34:39","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/"},"modified":"2023-12-06T05:56:34","modified_gmt":"2023-12-06T05:56:34","slug":"som-indien-bevat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/","title":{"rendered":"Hoe cellen met specifieke tekst toevoegen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-4279931770\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Om de waarden op te tellen van cellen waarin u specifieke tekst of gedeeltelijke tekst heeft, moet u <a href=\"https:\/\/exceladvisor.org\/nl\/wildcards-2\/\" data-wpil=\"url\">jokertekens<\/a> gebruiken met SUMIF. In het criteria-argument moet je voor en na de tekst een asterisk gebruiken met een ampersand, net zoals we in het volgende voorbeeld hebben gebruikt om de cellen op te tellen waar je de tekst &#8216;Mobiel&#8217; in de kolom &#8216;Product&#8217; hebt staan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77808\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-gedeeltelijke-tekst\" width=\"597\" height=\"298\"><\/figure><\/div><p> In deze tutorial leren we hoe we deze formule kunnen schrijven met SUMIF.<\/p><h2 class=\"wp-block-heading\"> Formule om toe te voegen ALS de cel specifieke tekst bevat<\/h2><ol><li> Voer eerst in cel C1 \u201c=SUMIF(\u201c.<\/li><li> Raadpleeg daarna het bereik waarvan we de criteria moeten controleren.<\/li><li> Voer nu in de criteria asterisk-criteria-asterisk in (\u201c*\u201d&amp;\u201dMobiel\u201d&amp;\u201d*\u201d).<\/li><li> Raadpleeg vervolgens in het argument sum_range de kolom Aantal.<\/li><li> Druk aan het einde op Enter om het resultaat te krijgen. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77809\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-comprendre-sumif-contient-une-formule-de-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"begrijp-sumif-bevat-tekstformule\" width=\"604\" height=\"140\"><\/figure><\/div><p class=\"formula\"> =SOM.ALS(A2:A10,\u201d*\u201d&amp;\u201dMobiel\u201d&amp;\u201d*\u201d,B2:B10) <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77810\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-referentie\" width=\"609\" height=\"468\"><\/figure><\/div><div class=\"gb-container gb-container-ad6b2fd6 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-ae10a664 gb-headline-text gb-headline-4f7959c2\"> Haal het Excel-bestand op<\/h2><p> <a class=\"gb-button gb-button-bd7e9e60 gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/sumif-contient-du-texte.xlsx\" rel=\"nofollow\">Downloaden<\/a><\/p><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/formules\/\">Lijst met Excel-formules<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Gerelateerde formules <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/som-indien-groter-dan\/\">Som groter dan waarden met SUMIF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/sumives-niet-gelijk\/\">Som van niet-gelijke waarden (SUMIFS) in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/sumif-sumifs-of-logica\/\">SUMIF\/SUMIFS met OR-logica in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/sumif-met-jokertekens\/\">SUMIF met jokertekens in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/som-van-waarden-tussen-twee-datums\/\">SUMIFS-datumbereik (som van waarden tussen twee datummatrices)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1736","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Hoe kan ik cellen met specifieke tekst toevoegen?<\/title>\n<meta name=\"description\" content=\"In deze tutorial leren we hoe we waarden kunnen toevoegen als een cel specifieke tekst bevat. Hiervoor kunt u gebruiken\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe kan ik cellen met specifieke tekst toevoegen?\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leren we hoe we waarden kunnen toevoegen als een cel specifieke tekst bevat. Hiervoor kunt u gebruiken\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:56:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/\",\"name\":\"\u25b7 Hoe kan ik cellen met specifieke tekst toevoegen?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\",\"datePublished\":\"2023-11-08T20:34:39+00:00\",\"dateModified\":\"2023-12-06T05:56:34+00:00\",\"description\":\"In deze tutorial leren we hoe we waarden kunnen toevoegen als een cel specifieke tekst bevat. Hiervoor kunt u gebruiken\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe cellen met specifieke tekst toevoegen?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Hoe kan ik cellen met specifieke tekst toevoegen?","description":"In deze tutorial leren we hoe we waarden kunnen toevoegen als een cel specifieke tekst bevat. Hiervoor kunt u gebruiken","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe kan ik cellen met specifieke tekst toevoegen?","og_description":"In deze tutorial leren we hoe we waarden kunnen toevoegen als een cel specifieke tekst bevat. Hiervoor kunt u gebruiken","og_url":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:56:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/","url":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/","name":"\u25b7 Hoe kan ik cellen met specifieke tekst toevoegen?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png","datePublished":"2023-11-08T20:34:39+00:00","dateModified":"2023-12-06T05:56:34+00:00","description":"In deze tutorial leren we hoe we waarden kunnen toevoegen als een cel specifieke tekst bevat. Hiervoor kunt u gebruiken","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-texte-partiel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/som-indien-bevat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe cellen met specifieke tekst toevoegen?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1736","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1736"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1736\/revisions"}],"predecessor-version":[{"id":3061,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1736\/revisions\/3061"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1736"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}