{"id":1593,"date":"2023-12-02T01:15:22","date_gmt":"2023-12-02T01:15:22","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=1593"},"modified":"2023-12-03T01:53:23","modified_gmt":"2023-12-03T01:53:23","slug":"funcao-somase-no-excel","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/","title":{"rendered":"SomaSe"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1593\" class=\"elementor elementor-1593\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47b0eaf elementor-widget elementor-widget-heading\" data-id=\"47b0eaf\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Fun\u00e7\u00e3o SomaSe no Excel<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1541628 e-flex e-con-boxed e-con e-parent\" data-id=\"1541628\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-afed85b elementor-widget elementor-widget-video\" data-id=\"afed85b\" data-element_type=\"widget\" data-settings=\"{&quot;video_type&quot;:&quot;hosted&quot;,&quot;autoplay&quot;:&quot;yes&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-hosted-video elementor-wrapper elementor-open-inline\">\n\t\t\t\t\t<video class=\"elementor-video\" src=\"https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/12\/somase.mp4\" autoplay=\"\" controls=\"\" controlsList=\"nodownload\"><\/video>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e494e11 e-flex e-con-boxed e-con e-parent\" data-id=\"e494e11\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-90860ef elementor-widget elementor-widget-text-editor\" data-id=\"90860ef\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A fun\u00e7\u00e3o SOMASE no Excel \u00e9 utilizada para realizar c\u00e1lculos condicionais em planilhas. Ela permite somar valores com base em um crit\u00e9rio espec\u00edfico.<\/p><h2>Exemplos da Fun\u00e7\u00e3o SOMASE:<\/h2><ol><li>Somar valores maiores que 10: <code>=SOMASE(A1:A5, \"&gt;10\")<\/code> soma os valores na coluna A maiores que 10.<\/li><li>Somar valores com base em texto: <code>=SOMASE(B1:B5, \"Ma\u00e7\u00e3\")<\/code> soma os valores na coluna B que s\u00e3o &#8220;Ma\u00e7\u00e3&#8221;.<\/li><li>Somar com crit\u00e9rios m\u00faltiplos: <code>=SOMASE(C1:C5, \"Vermelho\", D1:D5, \"&lt;&gt;Ma\u00e7\u00e3\")<\/code> soma valores em que a cor \u00e9 &#8220;Vermelho&#8221; e a fruta n\u00e3o \u00e9 &#8220;Ma\u00e7\u00e3&#8221;.<\/li><li>Somar com intervalos n\u00e3o cont\u00edguos: <code>=SOMASE(A1:A5, \"&gt;10\", C1:C5, \"&lt;&gt;Vermelho\")<\/code> soma valores com crit\u00e9rios em diferentes colunas.<\/li><li>Somar com base em datas: <code>=SOMASE(E1:E5, \"&lt;01\/01\/2023\")<\/code> soma valores anteriores a 01\/01\/2023 na coluna E.<\/li><\/ol><h2>Tabela de Palavras-chave:<\/h2><table><tbody><tr><th>Palavra-chave<\/th><th>Descri\u00e7\u00e3o<\/th><\/tr><tr><td>Excel<\/td><td>Software de planilha amplamente usado para an\u00e1lise de dados.<\/td><\/tr><tr><td>Fun\u00e7\u00e3o SOMASE<\/td><td>Uma f\u00f3rmula no Excel que realiza a soma condicional de valores.<\/td><\/tr><tr><td>C\u00e1lculos condicionais<\/td><td>Opera\u00e7\u00f5es matem\u00e1ticas que dependem de crit\u00e9rios espec\u00edficos para serem aplicadas.<\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ee1908c elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"ee1908c\" data-element_type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Caso queira receber esse arquivo Excel, contendo essa fun\u00e7\u00e3o , \u00e9 s\u00f3 enviar um e-mail <br>solicitando para o endere\u00e7o <br><strong>marmitanao@gmail.com<br><br><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9bdc2df e-flex e-con-boxed e-con e-parent\" data-id=\"9bdc2df\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-geradora-de-cpfs-validos\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de CPFs em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-geradora-de-cnpjs-validos\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-creative-commons-nd\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de CNPJs em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.facilitademais.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-americas\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Site para validar as fun\u00e7\u00f5es geradoras<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-geradora-de-cnhs\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-globe-africa\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de CNHs em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/gerar-senhas-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de Senhas em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/gerar-numeros-da-mega-sena\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Geradora de Mega Sena em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-eac2340 e-flex e-con-boxed e-con e-parent\" data-id=\"eac2340\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o SomaSe no Excel https:\/\/saibam.com.br\/excel\/wp-content\/uploads\/2023\/12\/somase.mp4 A fun\u00e7\u00e3o SOMASE no Excel \u00e9 utilizada para realizar c\u00e1lculos condicionais em planilhas. Ela permite somar valores com base em um crit\u00e9rio espec\u00edfico. Exemplos da Fun\u00e7\u00e3o SOMASE: Somar valores maiores que 10: =SOMASE(A1:A5, &#8220;&gt;10&#8221;) soma os valores na coluna A maiores que 10. Somar valores &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">SomaSe<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[154],"tags":[150,152,151,153],"class_list":["post-1593","post","type-post","status-publish","format-standard","hentry","category-excel-matematicas","tag-excel","tag-funcao-soma","tag-planilha","tag-soma"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SomaSe - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o SOMASE no Excel \u00e9 uma ferramenta poderosa para realizar c\u00e1lculos condicionais em planilhas. Com ela, \u00e9 poss\u00edvel somar valores com base em crit\u00e9rios espec\u00edficos, o que \u00e9 extremamente \u00fatil em an\u00e1lises de dados complexas. Nos exemplos fornecidos, voc\u00ea pode aprender a somar valores maiores que um determinado n\u00famero, com base em texto, usando m\u00faltiplos crit\u00e9rios e at\u00e9 mesmo em datas espec\u00edficas. O Excel, como uma ferramenta de planilha l\u00edder, oferece essa fun\u00e7\u00e3o para simplificar o processamento de dados, economizando tempo e garantindo precis\u00e3o. Entender e dominar a fun\u00e7\u00e3o SOMASE \u00e9 essencial para qualquer pessoa que trabalhe com planilhas e precise realizar c\u00e1lculos condicionais.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SomaSe - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o SOMASE no Excel \u00e9 uma ferramenta poderosa para realizar c\u00e1lculos condicionais em planilhas. Com ela, \u00e9 poss\u00edvel somar valores com base em crit\u00e9rios espec\u00edficos, o que \u00e9 extremamente \u00fatil em an\u00e1lises de dados complexas. Nos exemplos fornecidos, voc\u00ea pode aprender a somar valores maiores que um determinado n\u00famero, com base em texto, usando m\u00faltiplos crit\u00e9rios e at\u00e9 mesmo em datas espec\u00edficas. O Excel, como uma ferramenta de planilha l\u00edder, oferece essa fun\u00e7\u00e3o para simplificar o processamento de dados, economizando tempo e garantindo precis\u00e3o. Entender e dominar a fun\u00e7\u00e3o SOMASE \u00e9 essencial para qualquer pessoa que trabalhe com planilhas e precise realizar c\u00e1lculos condicionais.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-02T01:15:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T01:53:23+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/\",\"name\":\"SomaSe - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-12-02T01:15:22+00:00\",\"dateModified\":\"2023-12-03T01:53:23+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o SOMASE no Excel \u00e9 uma ferramenta poderosa para realizar c\u00e1lculos condicionais em planilhas. Com ela, \u00e9 poss\u00edvel somar valores com base em crit\u00e9rios espec\u00edficos, o que \u00e9 extremamente \u00fatil em an\u00e1lises de dados complexas. Nos exemplos fornecidos, voc\u00ea pode aprender a somar valores maiores que um determinado n\u00famero, com base em texto, usando m\u00faltiplos crit\u00e9rios e at\u00e9 mesmo em datas espec\u00edficas. O Excel, como uma ferramenta de planilha l\u00edder, oferece essa fun\u00e7\u00e3o para simplificar o processamento de dados, economizando tempo e garantindo precis\u00e3o. Entender e dominar a fun\u00e7\u00e3o SOMASE \u00e9 essencial para qualquer pessoa que trabalhe com planilhas e precise realizar c\u00e1lculos condicionais.\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SomaSe\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SomaSe - Saibam","description":"A fun\u00e7\u00e3o SOMASE no Excel \u00e9 uma ferramenta poderosa para realizar c\u00e1lculos condicionais em planilhas. Com ela, \u00e9 poss\u00edvel somar valores com base em crit\u00e9rios espec\u00edficos, o que \u00e9 extremamente \u00fatil em an\u00e1lises de dados complexas. Nos exemplos fornecidos, voc\u00ea pode aprender a somar valores maiores que um determinado n\u00famero, com base em texto, usando m\u00faltiplos crit\u00e9rios e at\u00e9 mesmo em datas espec\u00edficas. O Excel, como uma ferramenta de planilha l\u00edder, oferece essa fun\u00e7\u00e3o para simplificar o processamento de dados, economizando tempo e garantindo precis\u00e3o. Entender e dominar a fun\u00e7\u00e3o SOMASE \u00e9 essencial para qualquer pessoa que trabalhe com planilhas e precise realizar c\u00e1lculos condicionais.","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:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/","og_locale":"pt_PT","og_type":"article","og_title":"SomaSe - Saibam","og_description":"A fun\u00e7\u00e3o SOMASE no Excel \u00e9 uma ferramenta poderosa para realizar c\u00e1lculos condicionais em planilhas. Com ela, \u00e9 poss\u00edvel somar valores com base em crit\u00e9rios espec\u00edficos, o que \u00e9 extremamente \u00fatil em an\u00e1lises de dados complexas. Nos exemplos fornecidos, voc\u00ea pode aprender a somar valores maiores que um determinado n\u00famero, com base em texto, usando m\u00faltiplos crit\u00e9rios e at\u00e9 mesmo em datas espec\u00edficas. O Excel, como uma ferramenta de planilha l\u00edder, oferece essa fun\u00e7\u00e3o para simplificar o processamento de dados, economizando tempo e garantindo precis\u00e3o. Entender e dominar a fun\u00e7\u00e3o SOMASE \u00e9 essencial para qualquer pessoa que trabalhe com planilhas e precise realizar c\u00e1lculos condicionais.","og_url":"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/","og_site_name":"Saibam","article_published_time":"2023-12-02T01:15:22+00:00","article_modified_time":"2023-12-03T01:53:23+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/","url":"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/","name":"SomaSe - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-12-02T01:15:22+00:00","dateModified":"2023-12-03T01:53:23+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o SOMASE no Excel \u00e9 uma ferramenta poderosa para realizar c\u00e1lculos condicionais em planilhas. Com ela, \u00e9 poss\u00edvel somar valores com base em crit\u00e9rios espec\u00edficos, o que \u00e9 extremamente \u00fatil em an\u00e1lises de dados complexas. Nos exemplos fornecidos, voc\u00ea pode aprender a somar valores maiores que um determinado n\u00famero, com base em texto, usando m\u00faltiplos crit\u00e9rios e at\u00e9 mesmo em datas espec\u00edficas. O Excel, como uma ferramenta de planilha l\u00edder, oferece essa fun\u00e7\u00e3o para simplificar o processamento de dados, economizando tempo e garantindo precis\u00e3o. Entender e dominar a fun\u00e7\u00e3o SOMASE \u00e9 essencial para qualquer pessoa que trabalhe com planilhas e precise realizar c\u00e1lculos condicionais.","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/funcao-somase-no-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"SomaSe"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Dezembro 2, 2023","get_modified_date":"Dezembro 3, 2023","category_list":{"category":[{"term_id":154,"name":"Excel Matem\u00e1ticas","slug":"excel-matematicas","term_group":0,"term_taxonomy_id":154,"taxonomy":"category","description":"","parent":0,"count":3,"filter":"raw"}],"post_tag":[{"term_id":150,"name":"excel","slug":"excel","term_group":0,"term_taxonomy_id":150,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"},{"term_id":152,"name":"fun\u00e7\u00e3o soma","slug":"funcao-soma","term_group":0,"term_taxonomy_id":152,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"},{"term_id":151,"name":"planilha","slug":"planilha","term_group":0,"term_taxonomy_id":151,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"},{"term_id":153,"name":"soma","slug":"soma","term_group":0,"term_taxonomy_id":153,"taxonomy":"post_tag","description":"","parent":0,"count":5,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/excel-matematicas\/\" alt=\"Excel Matem\u00e1ticas\" class=\"category-excel-matematicas\">Excel Matem\u00e1ticas<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/excel\/\" alt=\"excel\" class=\"post_tag-excel\">excel<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-soma\/\" alt=\"fun\u00e7\u00e3o soma\" class=\"post_tag-funcao-soma\">fun\u00e7\u00e3o soma<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/planilha\/\" alt=\"planilha\" class=\"post_tag-planilha\">planilha<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/soma\/\" alt=\"soma\" class=\"post_tag-soma\">soma<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=1593"}],"version-history":[{"count":32,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1593\/revisions"}],"predecessor-version":[{"id":1630,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/1593\/revisions\/1630"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=1593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=1593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=1593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}