{"id":2926,"date":"2024-03-30T16:11:50","date_gmt":"2024-03-30T16:11:50","guid":{"rendered":"https:\/\/windowsreport.com\/pt\/?p=2926"},"modified":"2025-09-26T13:34:30","modified_gmt":"2025-09-26T10:34:30","slug":"formula-soma-do-excel-nao-soma-corretamente-como-corrigir","status":"publish","type":"post","link":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/","title":{"rendered":"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir"},"content":{"rendered":"<p>Como aplicativo de planilha, o Excel \u00e9 uma grande calculadora que tamb\u00e9m exibe dados num\u00e9ricos em tabelas e gr\u00e1ficos. A grande maioria dos usu\u00e1rios do Excel precisar\u00e1 utilizar a fun\u00e7\u00e3o (ou f\u00f3rmula) SUM do aplicativo. Como a fun\u00e7\u00e3o SOMA soma n\u00fameros, \u00e9 provavelmente a f\u00f3rmula mais utilizada do Excel.<\/p><p> A fun\u00e7\u00e3o SUM nunca calcular\u00e1 mal os n\u00fameros. No entanto, as c\u00e9lulas da fun\u00e7\u00e3o SUM nem sempre exibem os resultados esperados.<\/p><p> \u00c0s vezes, eles podem exibir mensagens de erro em vez de valores num\u00e9ricos. Em outros casos, as c\u00e9lulas da f\u00f3rmula SUM podem retornar apenas um valor zero. Estas s\u00e3o algumas maneiras de corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente.<\/p><h2 class=\"wp-block-heading\"> Por que a f\u00f3rmula SUM do Excel n\u00e3o est\u00e1 somando corretamente?<\/h2><p> Existem v\u00e1rios motivos pelos quais a f\u00f3rmula SUM no Excel pode n\u00e3o estar somando corretamente. Algumas causas poss\u00edveis incluem:<\/p><ul class=\"wp-block-list\"><li> <strong>A f\u00f3rmula est\u00e1 usando refer\u00eancias de c\u00e9lulas erradas<\/strong> : certifique-se de usar as refer\u00eancias de c\u00e9lulas corretas em sua f\u00f3rmula e de que as c\u00e9lulas referenciadas fazem parte dos dados que voc\u00ea deseja somar.<\/li><li> <strong>Existem linhas ou colunas ocultas que est\u00e3o sendo inclu\u00eddas no c\u00e1lculo<\/strong> : Se voc\u00ea tiver linhas ou colunas ocultas em seus dados, certifique-se de que elas n\u00e3o estejam sendo inclu\u00eddas no c\u00e1lculo por acidente. Voc\u00ea pode verificar isso observando as refer\u00eancias de c\u00e9lulas na f\u00f3rmula e vendo se elas incluem alguma c\u00e9lula oculta.<\/li><li> <strong>Existem c\u00e9lulas com texto ou erros<\/strong> : Se houver c\u00e9lulas no intervalo que est\u00e1 sendo somado que contenham texto ou erros, a f\u00f3rmula SUM n\u00e3o funcionar\u00e1 corretamente. Voc\u00ea pode corrigir isso certificando-se de que todas as c\u00e9lulas somadas contenham apenas dados num\u00e9ricos.<\/li><li> <strong>O formato da c\u00e9lula est\u00e1 definido como texto<\/strong> : Se o formato da c\u00e9lula estiver definido como texto, a f\u00f3rmula SUM n\u00e3o funcionar\u00e1 corretamente. Voc\u00ea pode corrigir isso selecionando as c\u00e9lulas que deseja somar e, em seguida, acessando a guia In\u00edcio na faixa de op\u00e7\u00f5es e clicando no menu suspenso \u201cN\u00famero\u201d no grupo \u201cN\u00famero\u201d. Escolha \u201cGeral\u201d ou outro formato num\u00e9rico da lista.<\/li><li> <strong>A f\u00f3rmula foi inserida incorretamente<\/strong> : certifique-se de usar a sintaxe correta para a f\u00f3rmula SUM, incluindo o sinal de igual (=) e os par\u00eanteses de abertura e fechamento.<\/li><\/ul><h2 class=\"wp-block-heading\"> Como posso corrigir fun\u00e7\u00f5es do Excel SUM que n\u00e3o batem? <\/h2><h3 class=\"wp-block-heading\"> 1. Verifique a sintaxe da fun\u00e7\u00e3o SUM<\/h3><p> Primeiro, verifique se voc\u00ea inseriu a fun\u00e7\u00e3o SUM na barra de f\u00f3rmulas com a sintaxe correta.<\/p><p> A sintaxe da fun\u00e7\u00e3o SUM \u00e9:<\/p><p> <kbd>=SOMA(n\u00famero 1, n\u00famero 2)<\/kbd><\/p><p> O n\u00famero 1 e o n\u00famero 2 podem ser um intervalo de c\u00e9lulas, portanto, uma fun\u00e7\u00e3o SOMA que adiciona as primeiras 10 c\u00e9lulas da coluna A ter\u00e1 a seguinte apar\u00eancia: =SOMA(A1:A10). Certifique-se de que n\u00e3o haja erros de digita\u00e7\u00e3o em nenhuma descri\u00e7\u00e3o dessa fun\u00e7\u00e3o que fa\u00e7a com que sua c\u00e9lula exiba um #Name? erro conforme mostrado diretamente abaixo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/sum-function.png\"><img decoding=\"async\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/sum-function.png\" alt=\"#NAME? cell error excel spreadsheet not adding up correctly\" class=\"wp-image-447714\" title=\"O nome? erro de c\u00e9lula\" \/><\/a><\/figure><\/div><h3 class=\"wp-block-heading\"> 2. Exclua espa\u00e7os da fun\u00e7\u00e3o SUM<\/h3><p> A fun\u00e7\u00e3o SOMA n\u00e3o soma nenhum valor quando h\u00e1 espa\u00e7os em sua f\u00f3rmula. Em vez disso, exibir\u00e1 a f\u00f3rmula em sua c\u00e9lula.<\/p><p> Para corrigir isso, selecione a c\u00e9lula da f\u00f3rmula; e clique na extremidade esquerda da barra de fun\u00e7\u00f5es. Pressione a tecla Backspace para remover quaisquer espa\u00e7os antes de &#039;=&#039; no in\u00edcio da fun\u00e7\u00e3o. Certifique-se de que n\u00e3o haja espa\u00e7os em nenhum outro lugar da f\u00f3rmula. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/SUM-function-that-includes-a-space.png\"><img decoding=\"async\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/SUM-function-that-includes-a-space.png\" alt=\"Function with spaces in it excel spreadsheet not adding up correctly\" class=\"wp-image-447713\" title=\"Uma fun\u00e7\u00e3o SUM com espa\u00e7os nela\" \/><\/a><\/figure><\/div><h3 class=\"wp-block-heading\">3. Amplie a coluna da f\u00f3rmula<\/h3><p> Se a c\u00e9lula da f\u00f3rmula SUM exibir #######, o valor poder\u00e1 n\u00e3o caber na c\u00e9lula. Portanto, pode ser necess\u00e1rio ampliar a coluna da c\u00e9lula para garantir que o n\u00famero inteiro caiba.<\/p><p> Para fazer isso, mova o cursor para o lado esquerdo ou direito da caixa de refer\u00eancia da coluna da c\u00e9lula SUM para que o cursor mude para uma seta dupla, como no instant\u00e2neo diretamente abaixo. Em seguida, segure o bot\u00e3o esquerdo do mouse e arraste a coluna para a esquerda ou direita para expandi-la. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/narrow-spreadsheet-column.png\"><img decoding=\"async\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/narrow-spreadsheet-column.png\" alt=\"Narrow spreadsheet column excel spreadsheet not adding up correctly\" class=\"wp-image-447712\" title=\"Uma coluna estreita da planilha\" \/><\/a><\/figure><\/div><h3 class=\"wp-block-heading\"> 4. Remova a formata\u00e7\u00e3o de texto das c\u00e9lulas<\/h3><p> A fun\u00e7\u00e3o Excel SUM n\u00e3o somar\u00e1 nenhum valor que esteja em c\u00e9lulas com formata\u00e7\u00e3o de texto, que exibem n\u00fameros de texto \u00e0 esquerda da c\u00e9lula em vez de \u00e0 direita. Para garantir que todas as c\u00e9lulas do intervalo de c\u00e9lulas de uma f\u00f3rmula SUM tenham formata\u00e7\u00e3o geral. Para corrigir isso, siga estas etapas.<\/p><ol class=\"wp-block-list\"><li> Selecione todas as c\u00e9lulas dentro do seu intervalo.<\/li><li> Em seguida, clique com o bot\u00e3o direito e selecione <strong>Formatar c\u00e9lulas<\/strong> para abrir a janela mostrada diretamente abaixo <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/The-Format-Cells-window.png\"><img decoding=\"async\" class=\"aligncenter wp-image-447711 size-full\" title=\"A janela Formatar c\u00e9lulas\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/The-Format-Cells-window.png\" alt=\"Format Cells window excel spreadsheet not adding up correctly\" width=\"509\" height=\"460\"><\/a><\/li><li> Selecione Geral na caixa Categoria.<\/li><li> Clique no bot\u00e3o <strong>OK<\/strong> .<\/li><li> Os n\u00fameros das c\u00e9lulas ainda estar\u00e3o em formato de texto. Voc\u00ea precisar\u00e1 clicar duas vezes em cada c\u00e9lula dentro do intervalo da fun\u00e7\u00e3o SUM e pressionar a tecla Enter para mudar seu n\u00famero para o formato geral selecionado.<br> <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/spreadsheet-with-text-cells.png\"><img decoding=\"async\" class=\"aligncenter wp-image-447710 size-full\" title=\"C\u00e9lulas Excel com formato de texto\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/spreadsheet-with-text-cells.png\" alt=\"Cells with text format excel spreadsheet not adding up correctly\" width=\"590\" height=\"294\"><\/a><\/li><li> Repita as etapas acima para a c\u00e9lula da f\u00f3rmula se essa c\u00e9lula exibir a fun\u00e7\u00e3o em vez de um valor.<\/li><\/ol><h3 class=\"wp-block-heading\"> 5. Selecione as op\u00e7\u00f5es Adicionar e Colar Valores Especiais<\/h3><p> Alternativamente, voc\u00ea pode adicionar valores em c\u00e9lulas com formata\u00e7\u00e3o de texto sem precisar convert\u00ea-los para geral com este truque.<\/p><ol class=\"wp-block-list\"><li> Clique com o bot\u00e3o direito em uma c\u00e9lula vazia e selecione <strong>Copiar<\/strong> .<\/li><li> Selecione todas as c\u00e9lulas de texto com o intervalo de c\u00e9lulas da fun\u00e7\u00e3o.<\/li><li> Clique no bot\u00e3o <strong>Colar<\/strong> .<\/li><li> Selecione <strong>Colar especial<\/strong> para abrir a janela mostrada diretamente abaixo. <a href=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/Paste-Special-window.png\"><img decoding=\"async\" class=\"aligncenter wp-image-447708 size-full\" title=\"A janela Colar especial\" src=\"https:\/\/windowsreport.com\/wp-content\/uploads\/2020\/02\/Paste-Special-window.png\" alt=\"Paste Special window excel spreadsheet not adding up correctly\" width=\"364\" height=\"325\"><\/a><\/li><li> Selecione as op\u00e7\u00f5es <strong>Valores<\/strong> e <strong>Adicionar<\/strong> l\u00e1.<\/li><li> Clique no bot\u00e3o <strong>OK<\/strong> . Em seguida, a fun\u00e7\u00e3o adicionar\u00e1 os n\u00fameros nas c\u00e9lulas de texto.<\/li><\/ol><p> Essas s\u00e3o algumas das melhores maneiras de corrigir f\u00f3rmulas de planilhas do Excel que n\u00e3o est\u00e3o somando corretamente.<\/p><p> Na maioria dos casos, a fun\u00e7\u00e3o SUM n\u00e3o soma porque n\u00e3o foi inserida corretamente ou porque sua refer\u00eancia de c\u00e9lula inclui c\u00e9lulas de texto.<\/p><p> Se voc\u00ea souber de alguma outra maneira de corrigir esse problema relacionado ao Excel, deixe uma mensagem na se\u00e7\u00e3o de coment\u00e1rios abaixo para que outros usu\u00e1rios possam tentar.<\/p>","protected":false},"excerpt":{"rendered":"<p>Como aplicativo de planilha, o Excel \u00e9 uma grande calculadora que tamb\u00e9m exibe dados num\u00e9ricos em tabelas e gr\u00e1ficos. A grande maioria dos usu\u00e1rios do Excel precisar\u00e1 utilizar a fun\u00e7\u00e3o (ou f\u00f3rmula) SUM do aplicativo. Como a fun\u00e7\u00e3o SOMA soma n\u00fameros, \u00e9 provavelmente a f\u00f3rmula mais utilizada do Excel. A fun\u00e7\u00e3o SUM nunca calcular\u00e1 mal [&hellip;]<\/p>\n","protected":false},"author":2284,"featured_media":2927,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_enabled_clarity":"","footnotes":""},"categories":[55],"tags":[184],"work":[],"class_list":["post-2926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-excel"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir - WindowsReport<\/title>\n<meta name=\"description\" content=\"Para corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente, verifique a sintaxe da fun\u00e7\u00e3o SUM e certifique-se de que n\u00e3o haja c\u00e9lulas em formato de texto na planilha.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir\" \/>\n<meta property=\"og:description\" content=\"Para corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente, verifique a sintaxe da fun\u00e7\u00e3o SUM e certifique-se de que n\u00e3o haja c\u00e9lulas em formato de texto na planilha.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/\" \/>\n<meta property=\"og:site_name\" content=\"WindowsReport\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-30T16:11:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-26T10:34:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/03\/Excel-SUM-Formula-Not-Adding-Correctly.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1280\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Guilherme Rodolfo\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Guilherme Rodolfo\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/\"},\"author\":{\"name\":\"Guilherme Rodolfo\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/person\\\/1238815d33479055e23a293a045b4310\"},\"headline\":\"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir\",\"datePublished\":\"2024-03-30T16:11:50+00:00\",\"dateModified\":\"2025-09-26T10:34:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/\"},\"wordCount\":1093,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/03\\\/Excel-SUM-Formula-Not-Adding-Correctly.jpg\",\"keywords\":[\"excel\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/\",\"name\":\"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir - WindowsReport\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/03\\\/Excel-SUM-Formula-Not-Adding-Correctly.jpg\",\"datePublished\":\"2024-03-30T16:11:50+00:00\",\"dateModified\":\"2025-09-26T10:34:30+00:00\",\"description\":\"Para corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente, verifique a sintaxe da fun\u00e7\u00e3o SUM e certifique-se de que n\u00e3o haja c\u00e9lulas em formato de texto na planilha.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#primaryimage\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/03\\\/Excel-SUM-Formula-Not-Adding-Correctly.jpg\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/03\\\/Excel-SUM-Formula-Not-Adding-Correctly.jpg\",\"width\":1920,\"height\":1280},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#website\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/\",\"name\":\"WindowsReport\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#organization\",\"name\":\"WindowsReport\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/wr-logo-default-1.png\",\"contentUrl\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/01\\\/wr-logo-default-1.png\",\"width\":214,\"height\":35,\"caption\":\"WindowsReport\"},\"image\":{\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/#\\\/schema\\\/person\\\/1238815d33479055e23a293a045b4310\",\"name\":\"Guilherme Rodolfo\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g\",\"caption\":\"Guilherme Rodolfo\"},\"url\":\"https:\\\/\\\/windowsreport.com\\\/pt\\\/author\\\/guilhermerodolfo\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir - WindowsReport","description":"Para corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente, verifique a sintaxe da fun\u00e7\u00e3o SUM e certifique-se de que n\u00e3o haja c\u00e9lulas em formato de texto na planilha.","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:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/","og_locale":"pt_PT","og_type":"article","og_title":"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir","og_description":"Para corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente, verifique a sintaxe da fun\u00e7\u00e3o SUM e certifique-se de que n\u00e3o haja c\u00e9lulas em formato de texto na planilha.","og_url":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/","og_site_name":"WindowsReport","article_published_time":"2024-03-30T16:11:50+00:00","article_modified_time":"2025-09-26T10:34:30+00:00","og_image":[{"width":1920,"height":1280,"url":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/03\/Excel-SUM-Formula-Not-Adding-Correctly.jpg","type":"image\/jpeg"}],"author":"Guilherme Rodolfo","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Guilherme Rodolfo","Tempo estimado de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#article","isPartOf":{"@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/"},"author":{"name":"Guilherme Rodolfo","@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/person\/1238815d33479055e23a293a045b4310"},"headline":"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir","datePublished":"2024-03-30T16:11:50+00:00","dateModified":"2025-09-26T10:34:30+00:00","mainEntityOfPage":{"@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/"},"wordCount":1093,"commentCount":0,"publisher":{"@id":"https:\/\/windowsreport.com\/pt\/#organization"},"image":{"@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#primaryimage"},"thumbnailUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/03\/Excel-SUM-Formula-Not-Adding-Correctly.jpg","keywords":["excel"],"articleSection":["Tutoriais"],"inLanguage":"pt-PT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/windowsreport.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/","url":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/","name":"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir - WindowsReport","isPartOf":{"@id":"https:\/\/windowsreport.com\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#primaryimage"},"image":{"@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#primaryimage"},"thumbnailUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/03\/Excel-SUM-Formula-Not-Adding-Correctly.jpg","datePublished":"2024-03-30T16:11:50+00:00","dateModified":"2025-09-26T10:34:30+00:00","description":"Para corrigir uma planilha do Excel que n\u00e3o est\u00e1 somando corretamente, verifique a sintaxe da fun\u00e7\u00e3o SUM e certifique-se de que n\u00e3o haja c\u00e9lulas em formato de texto na planilha.","breadcrumb":{"@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#primaryimage","url":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/03\/Excel-SUM-Formula-Not-Adding-Correctly.jpg","contentUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/03\/Excel-SUM-Formula-Not-Adding-Correctly.jpg","width":1920,"height":1280},{"@type":"BreadcrumbList","@id":"https:\/\/windowsreport.com\/pt\/formula-soma-do-excel-nao-soma-corretamente-como-corrigir\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/windowsreport.com\/pt\/"},{"@type":"ListItem","position":2,"name":"F\u00f3rmula SOMA do Excel n\u00e3o soma corretamente: como corrigir"}]},{"@type":"WebSite","@id":"https:\/\/windowsreport.com\/pt\/#website","url":"https:\/\/windowsreport.com\/pt\/","name":"WindowsReport","description":"","publisher":{"@id":"https:\/\/windowsreport.com\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/windowsreport.com\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/windowsreport.com\/pt\/#organization","name":"WindowsReport","url":"https:\/\/windowsreport.com\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/01\/wr-logo-default-1.png","contentUrl":"https:\/\/windowsreport.com\/pt\/wp-content\/uploads\/sites\/2\/2024\/01\/wr-logo-default-1.png","width":214,"height":35,"caption":"WindowsReport"},"image":{"@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/windowsreport.com\/pt\/#\/schema\/person\/1238815d33479055e23a293a045b4310","name":"Guilherme Rodolfo","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/secure.gravatar.com\/avatar\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/57ef39aead1ebe1bdee29ae5455b61e211a6454453ea9a9ad0713d8ca6030df0?s=96&d=https%3A%2F%2Fwindowsreport.com%2Fwp-content%2Fuploads%2Fsites%2F2%2F2024%2F01%2Fwricon.png&r=g","caption":"Guilherme Rodolfo"},"url":"https:\/\/windowsreport.com\/pt\/author\/guilhermerodolfo\/"}]}},"_links":{"self":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts\/2926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/users\/2284"}],"replies":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/comments?post=2926"}],"version-history":[{"count":1,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts\/2926\/revisions"}],"predecessor-version":[{"id":2928,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/posts\/2926\/revisions\/2928"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/media\/2927"}],"wp:attachment":[{"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/media?parent=2926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/categories?post=2926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/tags?post=2926"},{"taxonomy":"work","embeddable":true,"href":"https:\/\/windowsreport.com\/pt\/wp-json\/wp\/v2\/work?post=2926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}