{"id":329,"date":"2023-11-03T20:12:00","date_gmt":"2023-11-03T20:12:00","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/"},"modified":"2023-12-06T11:33:52","modified_gmt":"2023-12-06T11:33:52","slug":"soma-se-estiver-vazio-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/","title":{"rendered":"Como adicionar c\u00e9lulas vazias no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-684029458\"><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><div class=\"excel-before-content\" id=\"excel-630466902\"><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>Para usar SUMIF para somar valores de crit\u00e9rios vazios, basta especificar um valor vazio no argumento de crit\u00e9rios da fun\u00e7\u00e3o SUMIF. Com isso, diga ao Excel para considerar apenas c\u00e9lulas onde n\u00e3o haja valor. No exemplo abaixo, temos tr\u00eas c\u00e9lulas vazias na coluna do nome para as quais precisamos somar o valor da doa\u00e7\u00e3o. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77799\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"soma se para valores em branco\" width=\"540\" height=\"519\"><\/figure><\/div><p> Neste tutorial, aprenderemos como usar a fun\u00e7\u00e3o SUMIF ou SUMIFS para adicionar valores vazios.<\/p><h2 class=\"wp-block-heading\"> Escreva uma f\u00f3rmula para usar SUMIF para valores vazios<\/h2><ol type=\"1\"><li> Primeiro, insira SUMIF em uma c\u00e9lula onde deseja calcular a soma.<\/li><li> Agora consulte a coluna Nome onde voc\u00ea tem c\u00e9lulas em branco.<\/li><li> Depois disso, insira aspas duplas (inicial e final).<\/li><li> A seguir, consulte a coluna Doa\u00e7\u00e3o de onde voc\u00ea precisa somar os valores.<\/li><li> No final, pressione Enter para obter o resultado. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77800\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Formule-2-sumif-pour-les-valeurs-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmula sumif para valores em branco\" width=\"632\" height=\"459\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-Visual Basic\" lang=\"Visual Basic\">=SUMIF(A2:A13,\"\",B2:B13)<\/code><\/pre><h2 class=\"wp-block-heading\"> Um problema que voc\u00ea pode enfrentar<\/h2><p> Pode haver uma situa\u00e7\u00e3o em que voc\u00ea tenha um intervalo de c\u00e9lulas em que haja uma c\u00e9lula ou v\u00e1rias c\u00e9lulas com um espa\u00e7o como valor na c\u00e9lula que se parece com uma c\u00e9lula vazia, mas n\u00e3o com uma c\u00e9lula vazia.<\/p><p> Neste caso, SUMIF ir\u00e1 ignorar esta c\u00e9lula e n\u00e3o a incluir\u00e1 no c\u00e1lculo da soma. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77801\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-sumif-ignore-les-cellules-vides-avec-espace.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-ignorar-c\u00e9lulas-vazias-com-espa\u00e7o\" width=\"441\" height=\"378\"><\/figure><\/div><p> Aqui voc\u00ea pode criar uma f\u00f3rmula usando SUMIFS e SUM para criar um SUMIF OR. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77802\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-somme-et-somme-si.png\" sizes=\"auto, \" srcset=\"\" alt=\"soma e soma\" width=\"482\" height=\"368\"><\/figure><\/div><p> Nesta f\u00f3rmula, voc\u00ea deve especificar dois crit\u00e9rios no argumento crit\u00e9rio1 usando chaves.<\/p><ul><li> Espa\u00e7o<\/li><li> Branco <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77803\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-espace-a-deux-criteres-et-blanc.png\" sizes=\"auto, \" srcset=\"\" alt=\"dois crit\u00e9rios-espa\u00e7o e branco\" width=\"607\" height=\"102\"><\/figure><\/div><p> Ao fazer isso, o SUMIF considera os dois crit\u00e9rios simultaneamente. E para obter o resultado, voc\u00ea precisa inseri-lo como uma f\u00f3rmula de matriz (use Ctrl + Alt + Enter).<\/p><p class=\"formula\"> =SOMA(SOMASE(B2:B13,A2:A13,{\u201c\u201d,\u201d \u201c}))<\/p><p> Voc\u00ea pode encontrar mais <a href=\"https:\/\/exceladvisor.org\/pt\/copiar-colar\/\">aqui<\/a> . <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtenha o arquivo Excel<\/h2><p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-si-vide.xlsx\" rel=\"nofollow\">Download<\/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\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/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\/pt\/soma-se-contem\/\">Soma SE a c\u00e9lula cont\u00e9m texto espec\u00edfico (texto parcial SUMIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/sumif-ano-2\/\">Soma dos valores de acordo com o ano (Ano SUMIF)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/soma-por-data\/\">SUMIF por data (soma dos valores com base em uma data)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/\">SUMIF n\u00e3o vazio (soma de valores para c\u00e9lulas n\u00e3o vazias)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/soma-se-for-menor-que\/\">Soma dos valores menores que um determinado valor (SUMIF menor que)<\/a><\/li><\/ul><\/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-329","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 Como adicionar c\u00e9lulas vazias no Excel?<\/title>\n<meta name=\"description\" content=\"Neste tutorial aprenderemos como adicionar valores com base em c\u00e9lulas vazias. Se uma c\u00e9lula estiver vazia, isso ser\u00e1 levado\" \/>\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\/pt\/soma-se-estiver-vazio-2\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como adicionar c\u00e9lulas vazias no Excel?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial aprenderemos como adicionar valores com base em c\u00e9lulas vazias. Se uma c\u00e9lula estiver vazia, isso ser\u00e1 levado\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:33:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/\",\"name\":\"\u25b7 Como adicionar c\u00e9lulas vazias no Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\",\"datePublished\":\"2023-11-03T20:12:00+00:00\",\"dateModified\":\"2023-12-06T11:33:52+00:00\",\"description\":\"Neste tutorial aprenderemos como adicionar valores com base em c\u00e9lulas vazias. Se uma c\u00e9lula estiver vazia, isso ser\u00e1 levado\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como adicionar c\u00e9lulas vazias no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Como adicionar c\u00e9lulas vazias no Excel?","description":"Neste tutorial aprenderemos como adicionar valores com base em c\u00e9lulas vazias. Se uma c\u00e9lula estiver vazia, isso ser\u00e1 levado","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\/pt\/soma-se-estiver-vazio-2\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como adicionar c\u00e9lulas vazias no Excel?","og_description":"Neste tutorial aprenderemos como adicionar valores com base em c\u00e9lulas vazias. Se uma c\u00e9lula estiver vazia, isso ser\u00e1 levado","og_url":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:33:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/","url":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/","name":"\u25b7 Como adicionar c\u00e9lulas vazias no Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","datePublished":"2023-11-03T20:12:00+00:00","dateModified":"2023-12-06T11:33:52+00:00","description":"Neste tutorial aprenderemos como adicionar valores com base em c\u00e9lulas vazias. Se uma c\u00e9lula estiver vazia, isso ser\u00e1 levado","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sumif-pour-les-valeurs-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/soma-se-estiver-vazio-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como adicionar c\u00e9lulas vazias no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/329\/revisions"}],"predecessor-version":[{"id":779,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/329\/revisions\/779"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}