{"id":258,"date":"2023-11-08T21:16:36","date_gmt":"2023-11-08T21:16:36","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/"},"modified":"2023-12-06T11:33:51","modified_gmt":"2023-12-06T11:33:51","slug":"soma-se-nao-estiver-vazio-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/","title":{"rendered":"Como adicionar c\u00e9lulas n\u00e3o vazias?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-2595990744\"><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-2201746068\"><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 somar o valor das c\u00e9lulas que n\u00e3o est\u00e3o em branco, voc\u00ea deve especificar um valor que n\u00e3o esteja em branco (&#8220;&lt;&gt;&#8221; usando o operador maior que e menor que) no argumento de crit\u00e9rio da fun\u00e7\u00e3o. Com isso, o SUMIF ir\u00e1 procurar apenas c\u00e9lulas que n\u00e3o estejam em branco e considerar apenas valores [sum_range] com base nisso. Abaixo calculamos a soma das doa\u00e7\u00f5es com nomes. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77827\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-c\u00e9lulas n\u00e3o vazias\" width=\"542\" height=\"431\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Usando SUMIF para c\u00e9lulas n\u00e3o vazias<\/h2><ol type=\"1\"><li> Primeiro, na c\u00e9lula, insira =SUMIF(.<\/li><li> Agora nos crit\u00e9rios de intervalo consulte o intervalo A2:A13.<\/li><li> A seguir, insira os crit\u00e9rios para c\u00e9lulas n\u00e3o vazias usando \u201c&lt;&gt;\u201d.<\/li><li> Depois disso, no argumento [sum_range], consulte o intervalo B2:B13.<\/li><li> No final, insira os par\u00eanteses de fechamento e 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-77828\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-sumif-pour-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-sumif-para-c\u00e9lulas n\u00e3o vazias\" width=\"709\" height=\"201\"><\/figure><\/div><p> Ao inserir a f\u00f3rmula e pressionar Enter, ela retorna o valor da doa\u00e7\u00e3o apenas para as c\u00e9lulas onde voc\u00ea tem um nome na coluna de nome. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77829\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-resultats-sumif-pour-les-cellules-non-vides.png\" sizes=\"auto, \" srcset=\"\" alt=\"resultado sumif para c\u00e9lulas n\u00e3o vazias\" width=\"585\" height=\"446\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(A2:A13,\"&lt;&gt;\",B2:B13)<\/code><\/pre><h2 class=\"wp-block-heading\"> SUMPRODUCT para SUM C\u00e9lulas reais n\u00e3o vazias<\/h2><p> Digamos que voc\u00ea tenha uma c\u00e9lula vazia e nessa c\u00e9lula voc\u00ea tenha um espa\u00e7o. Agora esta <a href=\"https:\/\/exceladvisor.org\/pt\/remover-espacos-extras\/\">c\u00e9lula parece uma c\u00e9lula vazia, mas n\u00e3o vazia<\/a> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77830\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-sumproduct-pour-additionner-les-cellules-non-vides-reelles.png\" sizes=\"auto, \" srcset=\"\" alt=\"soma do produto com a soma real das c\u00e9lulas n\u00e3o vazias\" width=\"602\" height=\"303\"><\/figure><\/div><p> Nesta situa\u00e7\u00e3o, SUMIF tamb\u00e9m calcular\u00e1 a soma desta c\u00e9lula. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77831\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-comptes-de-sumif.png\" sizes=\"auto, \" srcset=\"\" alt=\"contagens sumif\" width=\"672\" height=\"229\"><\/figure><\/div><p> Para resolver esse problema, voc\u00ea pode usar uma combina\u00e7\u00e3o de <a href=\"https:\/\/exceladvisor.org\/pt\/somaproduto-2\/\">SUMPRODUCT<\/a> , LEN e TRIM. Com esta combina\u00e7\u00e3o voc\u00ea pode criar uma f\u00f3rmula de matriz. Veja o exemplo abaixo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77832\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Combinaison-de-garnitures-a-6-sumproduct-len.png\" sizes=\"auto, \" srcset=\"\" alt=\"combina\u00e7\u00e3o sumproduct-len-trim\" width=\"697\" height=\"347\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMPRODUCT(--(LEN(TRIM(A2:A13))&gt;0),B2:B13)<\/code><\/pre><p> Quando voc\u00ea insere esta fun\u00e7\u00e3o, ela remove esses espa\u00e7os em branco das c\u00e9lulas usando TRIM. Mas h\u00e1 uma coisa que voc\u00ea precisa saber sobre o SOMMEPROD. Pode ocupar uma tabela inteira em uma \u00fanica c\u00e9lula sem usar as teclas CTRL+ALT+ENTER.<\/p><p> Agora, vamos dividir essa f\u00f3rmula em cinco pequenas partes para entend\u00ea-la e ver como essa f\u00f3rmula incr\u00edvel funciona.<\/p><p> Na <strong>primeira parte<\/strong> , usamos TRIM e nos referimos a toda a coluna do nome. TRIM pega os valores das colunas e remove o espa\u00e7o das c\u00e9lulas onde voc\u00ea s\u00f3 tem espa\u00e7os. Estas s\u00e3o aquelas c\u00e9lulas que n\u00e3o t\u00eam valor, mas parecem c\u00e9lulas n\u00e3o vazias. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77833\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-premiere-garniture-part1.png\" sizes=\"auto, \" srcset=\"\" alt=\"primeira parte\" width=\"460\" height=\"282\"><\/figure><\/div><p> Na <strong>segunda parte<\/strong> temos LEN que conta o comprimento dos caracteres na coluna do nome. Para todas as c\u00e9lulas onde voc\u00ea n\u00e3o tem valores, a contagem de caracteres seria zero. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77834\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/partie-de-8-secondes.png\" sizes=\"auto, \" srcset=\"\" alt=\"segunda parte dois\" width=\"463\" height=\"240\"><\/figure><\/div><p> Como voc\u00ea pode ver, temos valores maiores que zero para todas as c\u00e9lulas n\u00e3o vazias.<\/p><p> Na <strong>terceira parte<\/strong> , usamos um operador maior que para comparar o resultado retornado por LEN e TRIM. E converte a contagem em VERDADEIRO e FALSO. Para um n\u00famero maior que zero, VERDADEIRO e, caso contr\u00e1rio, FALSO. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77835\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-utilise-plus-grand-que-loperateur.png\" sizes=\"auto, \" srcset=\"\" alt=\"usado maior que o operador\" width=\"554\" height=\"130\"><\/figure><\/div><p> Na <strong>quarta parte<\/strong> , temos um sinal de menos duplo que converte esses valores VERDADEIRO e FALSO em 0 e 1. Para VERDADEIRO, um 0 e FALSO, um 1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77836\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-double-moins-pour-convertir-vrai-et-faux.png\" sizes=\"auto, \" srcset=\"\" alt=\"duplo menos para converter verdadeiro em falso\" width=\"554\" height=\"134\"><\/figure><\/div><p> Depois disso, na quinta parte, temos SUMPRODUCT com dois arrays. E quando essas matrizes s\u00e3o multiplicadas entre si, voc\u00ea obt\u00e9m a soma apenas das c\u00e9lulas que n\u00e3o est\u00e3o vazias e n\u00e3o possuem espa\u00e7o invis\u00edvel. <\/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-non-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-for-maior-que\/\">Soma maior que valores usando SUMIF<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/sumivos-nao-sao-iguais\/\">Soma de valores diferentes (SUMIFS) no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/sumif-sumifs-ou-logica\/\">SUMIF\/SUMIFS com l\u00f3gica OR no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/sumif-com-curingas\/\">SUMIF com curingas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/soma-dos-valores-entre-duas-datas\/\">Intervalo de datas SUMIFS (soma dos valores entre duas matrizes de datas)<\/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-258","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 n\u00e3o vazias no Excel?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, aprenderemos como usar SUMIF para adicionar valores de c\u00e9lulas n\u00e3o vazias (n\u00e3o vazias) de um intervalo de c\u00e9lulas\" \/>\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-nao-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 n\u00e3o vazias no Excel?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, aprenderemos como usar SUMIF para adicionar valores de c\u00e9lulas n\u00e3o vazias (n\u00e3o vazias) de um intervalo de c\u00e9lulas\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:33:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-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=\"3 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-nao-estiver-vazio-2\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/\",\"name\":\"\u25b7 Como adicionar c\u00e9lulas n\u00e3o vazias no Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png\",\"datePublished\":\"2023-11-08T21:16:36+00:00\",\"dateModified\":\"2023-12-06T11:33:51+00:00\",\"description\":\"Neste tutorial, aprenderemos como usar SUMIF para adicionar valores de c\u00e9lulas n\u00e3o vazias (n\u00e3o vazias) de um intervalo de c\u00e9lulas\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/soma-se-nao-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 n\u00e3o vazias?\"}]},{\"@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 n\u00e3o vazias no Excel?","description":"Neste tutorial, aprenderemos como usar SUMIF para adicionar valores de c\u00e9lulas n\u00e3o vazias (n\u00e3o vazias) de um intervalo de c\u00e9lulas","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-nao-estiver-vazio-2\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como adicionar c\u00e9lulas n\u00e3o vazias no Excel?","og_description":"Neste tutorial, aprenderemos como usar SUMIF para adicionar valores de c\u00e9lulas n\u00e3o vazias (n\u00e3o vazias) de um intervalo de c\u00e9lulas","og_url":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:33:51+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/","url":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/","name":"\u25b7 Como adicionar c\u00e9lulas n\u00e3o vazias no Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png","datePublished":"2023-11-08T21:16:36+00:00","dateModified":"2023-12-06T11:33:51+00:00","description":"Neste tutorial, aprenderemos como usar SUMIF para adicionar valores de c\u00e9lulas n\u00e3o vazias (n\u00e3o vazias) de um intervalo de c\u00e9lulas","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-estiver-vazio-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-si-cellules-non-vides.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/soma-se-nao-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 n\u00e3o vazias?"}]},{"@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\/258","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=258"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/258\/revisions"}],"predecessor-version":[{"id":778,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/258\/revisions\/778"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}