{"id":8593,"date":"2026-07-22T12:31:05","date_gmt":"2026-07-22T12:31:05","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=8593"},"modified":"2026-09-26T13:31:24","modified_gmt":"2026-09-26T13:31:24","slug":"excel-somases-a-funcao-que-esta-revolucionando-a-forma-de-analisar-dados","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/excel-somases-a-funcao-que-esta-revolucionando-a-forma-de-analisar-dados\/","title":{"rendered":"Excel | SOMASES: A Fun\u00e7\u00e3o Que Est\u00e1 Revolucionando a Forma de Analisar Dados"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8593\" class=\"elementor elementor-8593\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-357889f e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"357889f\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-549ccc4 elementor-widget elementor-widget-heading\" data-id=\"549ccc4\" data-element_type=\"widget\" data-e-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\">- EXCEL \u2022 DICAS PR\u00c1TICAS -<\/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-40b0655 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"40b0655\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3c6add9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3c6add9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a7f66c1 elementor-widget elementor-widget-heading\" data-id=\"a7f66c1\" data-element_type=\"widget\" data-e-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\">SOMASES no Excel<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8902f91 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"8902f91\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-2112fd6 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"2112fd6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3e595d8 elementor-search-form--skin-classic elementor-search-form--button-type-icon elementor-search-form--icon-search elementor-widget elementor-widget-search-form\" data-id=\"3e595d8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;skin&quot;:&quot;classic&quot;}\" data-widget_type=\"search-form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<search role=\"search\">\n\t\t\t<form class=\"elementor-search-form\" action=\"https:\/\/fpw.com.br\/m\" method=\"get\">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-search-form__container\">\n\t\t\t\t\t<label class=\"elementor-screen-only\" for=\"elementor-search-form-3e595d8\">Search<\/label>\n\n\t\t\t\t\t\n\t\t\t\t\t<input id=\"elementor-search-form-3e595d8\" placeholder=\"Search...\" class=\"elementor-search-form__input\" type=\"search\" name=\"s\" value=\"\">\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<button class=\"elementor-search-form__submit\" type=\"submit\" aria-label=\"Search\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"e-font-icon-svg-container\"><svg class=\"fa fa-search e-font-icon-svg e-fas-search\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M505 442.7L405.3 343c-4.5-4.5-10.6-7-17-7H372c27.6-35.3 44-79.7 44-128C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c48.3 0 92.7-16.4 128-44v16.3c0 6.4 2.5 12.5 7 17l99.7 99.7c9.4 9.4 24.6 9.4 33.9 0l28.3-28.3c9.4-9.4 9.4-24.6.1-34zM208 336c-70.7 0-128-57.2-128-128 0-70.7 57.2-128 128-128 70.7 0 128 57.2 128 128 0 70.7-57.2 128-128 128z\"><\/path><\/svg><\/div>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/form>\n\t\t<\/search>\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<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b6fbbe7 elementor-widget elementor-widget-text-editor\" data-id=\"b6fbbe7\" data-element_type=\"widget\" data-e-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<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"i146er\" data-start=\"997\" data-end=\"1075\">A Fun\u00e7\u00e3o Que Est\u00e1 Revolucionando a Forma de Analisar Dados<\/h1><p data-start=\"1077\" data-end=\"1240\">Em um cen\u00e1rio onde empresas geram milhares de registros diariamente, encontrar informa\u00e7\u00f5es espec\u00edficas deixou de ser um diferencial e passou a ser uma necessidade.<\/p><p data-start=\"1242\" data-end=\"1275\">Imagine responder perguntas como:<\/p><ul data-start=\"1277\" data-end=\"1536\"><li data-section-id=\"sgl0tg\" data-start=\"1277\" data-end=\"1319\">Quanto foi vendido apenas na Regi\u00e3o Sul?<\/li><li data-section-id=\"17nerjw\" data-start=\"1320\" data-end=\"1378\">Qual foi o faturamento do vendedor Jo\u00e3o no m\u00eas de junho?<\/li><li data-section-id=\"16r3y58\" data-start=\"1379\" data-end=\"1437\">Quanto a empresa gastou apenas com o setor de Marketing?<\/li><li data-section-id=\"q23vcm\" data-start=\"1438\" data-end=\"1486\">Qual o total de horas extras do turno noturno?<\/li><li data-section-id=\"kfz9kd\" data-start=\"1487\" data-end=\"1536\">Quanto foi pago apenas aos funcion\u00e1rios ativos?<\/li><\/ul><p data-start=\"1538\" data-end=\"1590\">Tudo isso pode ser resolvido com apenas uma f\u00f3rmula.<\/p><p data-start=\"1592\" data-end=\"1639\">\u00c9 exatamente para isso que serve o <strong data-start=\"1627\" data-end=\"1638\">SOMASES<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-223f332 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"223f332\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-321b070 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"321b070\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1611c35 wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"1611c35\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"wpr-grid-filters elementor-clearfix wpr-grid-filters-sep-right\"><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span  data-filter=\"*\" class=\"wpr-grid-filters-item wpr-active-filter \">All Posts<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"blog\"]  data-filter=\".category-blog\">Blog<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"certificados\"]  data-filter=\".category-certificados\">Certificados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dados\"]  data-filter=\".category-dados\">Dados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dashboard\"]  data-filter=\".category-dashboard\">Dashboard<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"diversos\"]  data-filter=\".category-diversos\">Diversos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"excel\"]  data-filter=\".category-excel\">Excel<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"fpw\"]  data-filter=\".category-fpw\">FPw<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"membros\"]  data-filter=\".category-membros\">Membros<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"noticias\"]  data-filter=\".category-noticias\">Not\u00c3\u00adcias<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"planilhas\"]  data-filter=\".category-planilhas\">Planilhas<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"produtos\"]  data-filter=\".category-produtos\">Produtos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"sql\"]  data-filter=\".category-sql\">SQL<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"tecnologia\"]  data-filter=\".category-tecnologia\">Tecnologia<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"wordpress\"]  data-filter=\".category-wordpress\">WordPress<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><\/ul><section class=\"wpr-grid elementor-clearfix\" data-settings=\"{&quot;layout&quot;:&quot;fitRows&quot;,&quot;stick_last_element_to_bottom&quot;:&quot;&quot;,&quot;columns_desktop&quot;:3,&quot;gutter_hr&quot;:15,&quot;gutter_hr_mobile&quot;:15,&quot;gutter_hr_mobile_extra&quot;:15,&quot;gutter_hr_tablet&quot;:15,&quot;gutter_hr_tablet_extra&quot;:15,&quot;gutter_hr_laptop&quot;:15,&quot;gutter_hr_widescreen&quot;:15,&quot;gutter_vr&quot;:15,&quot;gutter_vr_mobile&quot;:15,&quot;gutter_vr_mobile_extra&quot;:15,&quot;gutter_vr_tablet&quot;:15,&quot;gutter_vr_tablet_extra&quot;:15,&quot;gutter_vr_laptop&quot;:15,&quot;gutter_vr_widescreen&quot;:15,&quot;animation&quot;:&quot;default&quot;,&quot;animation_duration&quot;:0.3,&quot;animation_delay&quot;:0.1,&quot;deeplinking&quot;:&quot;&quot;,&quot;filters_linkable&quot;:&quot;no&quot;,&quot;filters_default_filter&quot;:&quot;&quot;,&quot;filters_count&quot;:&quot;&quot;,&quot;filters_hide_empty&quot;:&quot;no&quot;,&quot;filters_animation&quot;:&quot;default&quot;,&quot;filters_animation_duration&quot;:0.3,&quot;filters_animation_delay&quot;:0.1,&quot;pagination_type&quot;:&quot;load-more&quot;,&quot;pagination_max_pages&quot;:116,&quot;lightbox&quot;:{&quot;selector&quot;:&quot;.wpr-grid-image-wrap&quot;,&quot;iframeMaxWidth&quot;:&quot;60%&quot;,&quot;hash&quot;:false,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause&quot;:5000,&quot;progressBar&quot;:&quot;true&quot;,&quot;counter&quot;:&quot;true&quot;,&quot;controls&quot;:&quot;true&quot;,&quot;getCaptionFromTitleOrAlt&quot;:&quot;true&quot;,&quot;thumbnail&quot;:&quot;&quot;,&quot;showThumbByDefault&quot;:&quot;&quot;,&quot;share&quot;:&quot;&quot;,&quot;zoom&quot;:&quot;true&quot;,&quot;fullScreen&quot;:&quot;true&quot;,&quot;download&quot;:&quot;true&quot;}}\" data-advanced-filters=\"no\"><article class=\"wpr-grid-item elementor-clearfix post-10045 post type-post status-publish format-standard has-post-thumbnail hentry category-planilhas tag-excel tag-menu-dados-completo tag-pacote-de-graficos tag-saiba-tudo-da-parte-de-dados tag-todos-os-arquivos\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/painel-financeiro.png\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/painel-financeiro.png\" alt=\"Dashboard Financeiro Completo\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/planilhas-dashboard-financeiro-completo\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-dashboard-financeiro-completo\/\">Planilhas | Dashboard Financeiro Completo<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-dashboard-financeiro-completo\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-10004 post type-post status-publish format-standard has-post-thumbnail hentry category-planilhas tag-excel tag-menu-dados-completo tag-pacote-de-graficos tag-saiba-tudo-da-parte-de-dados tag-todos-os-arquivos\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/indicadores-de-rh-1.png\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/indicadores-de-rh-1.png\" alt=\"Indicadores de RH 2.6\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/planilhas-indicadores-de-rh-2-6\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-indicadores-de-rh-2-6\/\">Planilhas | Indicadores de RH 2.6<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/planilhas-indicadores-de-rh-2-6\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9992 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw category-tecnologia tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-lg-nuvem tag-o-que-significa-fpw tag-porque-o-fpw-trocou-de-nome tag-sistema-fpw-da-lg-sistemas-uma-visao-abrangente\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/Transforme-seu-RH-com-agentes-de-IA-dados-e-Tecnologia.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/10\/Transforme-seu-RH-com-agentes-de-IA-dados-e-Tecnologia.jpg\" alt=\"Transforme seu RH com agentes de IA, dados e Tecnologia\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/fpw-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\">FPw | Transforme seu RH com agentes de IA, dados e Tecnologia<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-transforme-seu-rh-com-agentes-de-ia-dados-e-tecnologia\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><\/section>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a4e5f7 elementor-widget elementor-widget-text-editor\" data-id=\"2a4e5f7\" data-element_type=\"widget\" data-e-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<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"1jf147w\" data-start=\"1646\" data-end=\"1673\">O que \u00e9 a fun\u00e7\u00e3o SOMASES?<\/h1><p data-start=\"1675\" data-end=\"1756\">A fun\u00e7\u00e3o <strong data-start=\"1684\" data-end=\"1695\">SOMASES<\/strong> soma valores que atendem simultaneamente a v\u00e1rios crit\u00e9rios.<\/p><p data-start=\"1758\" data-end=\"1782\">Sua estrutura \u00e9 simples:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=SOMASES(intervalo_soma; intervalo_crit\u00e9rio1; crit\u00e9rio1; intervalo_crit\u00e9rio2; crit\u00e9rio2...)<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"1890\" data-end=\"2020\">Enquanto a fun\u00e7\u00e3o <strong data-start=\"1908\" data-end=\"1918\">SOMASE<\/strong> trabalha com apenas uma condi\u00e7\u00e3o, o <strong data-start=\"1955\" data-end=\"1966\">SOMASES<\/strong> permite utilizar dezenas de crit\u00e9rios ao mesmo tempo.<\/p><p data-start=\"2022\" data-end=\"2103\">Essa capacidade torna a fun\u00e7\u00e3o extremamente poderosa para an\u00e1lises profissionais.<\/p>\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-86403a5 elementor-widget elementor-widget-video\" data-id=\"86403a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=_AeEMfOlsEc&quot;,&quot;video_type&quot;:&quot;youtube&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=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-621913e elementor-widget elementor-widget-text-editor\" data-id=\"621913e\" data-element_type=\"widget\" data-e-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<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"1ujauwi\" data-start=\"2110\" data-end=\"2127\">Exemplo pr\u00e1tico<\/h1><p data-start=\"2129\" data-end=\"2155\">Imagine a seguinte tabela:<\/p><div class=\"TyagGW_tableContainer\"><div class=\"group TyagGW_tableWrapper flex flex-col-reverse w-fit\" tabindex=\"-1\"><table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"2157\" data-end=\"2373\"><thead data-start=\"2157\" data-end=\"2196\"><tr data-start=\"2157\" data-end=\"2196\"><th class=\"last:pe-10\" data-start=\"2157\" data-end=\"2168\" data-col-size=\"sm\">Vendedor<\/th><th class=\"last:pe-10\" data-start=\"2168\" data-end=\"2177\" data-col-size=\"sm\">Regi\u00e3o<\/th><th class=\"last:pe-10\" data-start=\"2177\" data-end=\"2187\" data-col-size=\"sm\">Produto<\/th><th class=\"last:pe-10\" data-start=\"2187\" data-end=\"2196\" data-col-size=\"sm\">Valor<\/th><\/tr><\/thead><tbody data-start=\"2241\" data-end=\"2373\"><tr data-start=\"2241\" data-end=\"2273\"><td data-start=\"2241\" data-end=\"2248\" data-col-size=\"sm\">Jo\u00e3o<\/td><td data-col-size=\"sm\" data-start=\"2248\" data-end=\"2254\">Sul<\/td><td data-col-size=\"sm\" data-start=\"2254\" data-end=\"2265\">Notebook<\/td><td data-col-size=\"sm\" data-start=\"2265\" data-end=\"2273\">3500<\/td><\/tr><tr data-start=\"2274\" data-end=\"2307\"><td data-start=\"2274\" data-end=\"2281\" data-col-size=\"sm\">Jo\u00e3o<\/td><td data-col-size=\"sm\" data-start=\"2281\" data-end=\"2289\">Norte<\/td><td data-col-size=\"sm\" data-start=\"2289\" data-end=\"2299\">Monitor<\/td><td data-col-size=\"sm\" data-start=\"2299\" data-end=\"2307\">1200<\/td><\/tr><tr data-start=\"2308\" data-end=\"2339\"><td data-start=\"2308\" data-end=\"2314\" data-col-size=\"sm\">Ana<\/td><td data-start=\"2314\" data-end=\"2320\" data-col-size=\"sm\">Sul<\/td><td data-col-size=\"sm\" data-start=\"2320\" data-end=\"2331\">Notebook<\/td><td data-col-size=\"sm\" data-start=\"2331\" data-end=\"2339\">4200<\/td><\/tr><tr data-start=\"2340\" data-end=\"2373\"><td data-start=\"2340\" data-end=\"2347\" data-col-size=\"sm\">Jo\u00e3o<\/td><td data-start=\"2347\" data-end=\"2353\" data-col-size=\"sm\">Sul<\/td><td data-start=\"2353\" data-end=\"2366\" data-col-size=\"sm\">Impressora<\/td><td data-col-size=\"sm\" data-start=\"2366\" data-end=\"2373\">900<\/td><\/tr><\/tbody><\/table><\/div><\/div><p data-start=\"2375\" data-end=\"2437\">Voc\u00ea deseja descobrir quanto Jo\u00e3o vendeu apenas na Regi\u00e3o Sul.<\/p><p data-start=\"2439\" data-end=\"2455\">A f\u00f3rmula seria:<\/p><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=SOMASES(D2:D5;A2:A5;\"Jo\u00e3o\";B2:B5;\"Sul\")<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"2512\" data-end=\"2522\">Resultado:<\/p><p data-start=\"2524\" data-end=\"2536\"><strong data-start=\"2524\" data-end=\"2536\">R$ 4.400<\/strong><\/p><p data-start=\"2538\" data-end=\"2550\">Sem filtros.<\/p><p data-start=\"2552\" data-end=\"2573\">Sem c\u00e1lculos manuais.<\/p><p data-start=\"2575\" data-end=\"2592\">Sem perder tempo.<\/p><hr data-start=\"2594\" data-end=\"2597\" \/><h1 data-section-id=\"4p7yen\" data-start=\"2599\" data-end=\"2637\">O grande segredo que poucos conhecem<\/h1><p data-start=\"2639\" data-end=\"2697\">A maioria das pessoas utiliza o SOMASES apenas com textos.<\/p><p data-start=\"2699\" data-end=\"2744\">Mas \u00e9 poss\u00edvel combinar crit\u00e9rios utilizando:<\/p><ul data-start=\"2746\" data-end=\"2860\"><li data-section-id=\"16wrx7v\" data-start=\"2746\" data-end=\"2753\">Datas<\/li><li data-section-id=\"gymi2i\" data-start=\"2754\" data-end=\"2763\">N\u00fameros<\/li><li data-section-id=\"1xzvj6d\" data-start=\"2764\" data-end=\"2774\">Per\u00edodos<\/li><li data-section-id=\"1f70kcv\" data-start=\"2775\" data-end=\"2788\">Compara\u00e7\u00f5es<\/li><li data-section-id=\"1cwz5a6\" data-start=\"2789\" data-end=\"2813\">Refer\u00eancias de c\u00e9lulas<\/li><li data-section-id=\"1itcdy5\" data-start=\"2814\" data-end=\"2838\">Operadores matem\u00e1ticos<\/li><li data-section-id=\"13p6ryx\" data-start=\"2839\" data-end=\"2860\">Caracteres curingas<\/li><\/ul><p data-start=\"2862\" data-end=\"2911\">Isso abre possibilidades praticamente ilimitadas.<\/p>\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-9668507 elementor-widget elementor-widget-heading\" data-id=\"9668507\" data-element_type=\"widget\" data-e-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\">Gostaria de aprimorar seu conhecimento em Excel,  aproveite nossos Cursos.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-502fce1 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"502fce1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-cca5de1 e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"cca5de1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4467ea2 elementor-widget elementor-widget-image\" data-id=\"4467ea2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/255edafd-e626-44de-832d-1be9942a5711\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo.png\" class=\"attachment-large size-large wp-image-9225\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Excel-Completo-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-702e69a elementor-widget elementor-widget-image\" data-id=\"702e69a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/6c607ccd-4032-41cf-a684-24e4155a6e2c\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png\" class=\"attachment-large size-large wp-image-9224\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-57a266a elementor-widget elementor-widget-image\" data-id=\"57a266a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/c606ba66-754d-4046-abba-14865ca84bea\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa.png\" class=\"attachment-large size-large wp-image-9226\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Fluxo-cde-Caixa-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-81b14bf elementor-widget elementor-widget-image\" data-id=\"81b14bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/3e5e88be-0c1f-4584-9e87-e79faadf4e16\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png\" class=\"attachment-large size-large wp-image-8381\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-cf79838 elementor-widget elementor-widget-image\" data-id=\"cf79838\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/93c20c84-4cf9-4b01-bde9-346688b1d1fb\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png\" class=\"attachment-large size-large wp-image-9223\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-5216ab6 elementor-widget elementor-widget-image\" data-id=\"5216ab6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/d64a7982-1d4d-4e14-94cb-36dc13f393c3\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png\" class=\"attachment-large size-large wp-image-9227\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be147cd elementor-widget elementor-widget-text-editor\" data-id=\"be147cd\" data-element_type=\"widget\" data-e-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<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"uebe8l\" data-start=\"2918\" data-end=\"2945\">Exemplos que impressionam<\/h1><h2 data-section-id=\"7t0ut3\" data-start=\"2947\" data-end=\"2980\">Somar vendas acima de R$ 5.000<\/h2><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=SOMASES(D:D;D:D;\"&gt;5000\")<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><hr data-start=\"3022\" data-end=\"3025\" \/><h2 data-section-id=\"1swduyp\" data-start=\"3027\" data-end=\"3059\">Somar apenas o m\u00eas de janeiro<\/h2><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=SOMASES(D:D;A:A;\"&gt;=01\/01\/2026\";A:A;\"&lt;=31\/01\/2026\")<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><hr data-start=\"3127\" data-end=\"3130\" \/><h2 data-section-id=\"1sqn31z\" data-start=\"3132\" data-end=\"3177\">Somar apenas produtos iniciados com &#8220;Note&#8221;<\/h2><div class=\"relative w-full mt-4 mb-1\"><div class=\"\"><div class=\"contents\"><div class=\"border border-token-border-light border-radius-3xl corner-superellipse\/1.1 rounded-3xl\"><div class=\"relative h-full w-full border-radius-3xl bg-(--code-block-surface) corner-superellipse\/1.1 overflow-clip rounded-3xl [--code-block-surface:var(--bg-elevated-secondary)] dark:[--code-block-surface:var(--composer-surface-primary)] lxnfua_clipPathFallback\"><div class=\"pointer-events-none absolute inset-x-4 top-12 bottom-4\"><div class=\"pointer-events-none sticky z-40 shrink-0 z-1!\"><div class=\"sticky bg-token-border-light\">\u00a0<\/div><\/div><\/div><div class=\"relative\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"h-full min-h-0 min-w-0\"><div class=\"\"><div class=\"relative\"><div class=\"\"><div class=\"relative z-0 flex max-w-full\"><div id=\"code-block-viewer\" class=\"q9tKkq_viewer cm-editor z-10 light:cm-light dark:cm-light flex h-full w-full flex-col items-stretch \u037cd \u037cr\" dir=\"ltr\"><div class=\"cm-scroller\"><pre class=\"cm-content q9tKkq_readonly m-0\"><code>=SOMASES(D:D;C:C;\"Note*\")<\/code><\/pre><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><div class=\"\"><div class=\"\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><p data-start=\"3219\" data-end=\"3267\">O asterisco (*) funciona como caractere curinga.<\/p><p data-start=\"3269\" data-end=\"3302\">Pouca gente utiliza esse recurso.<\/p><hr data-start=\"3304\" data-end=\"3307\" \/><h1 data-section-id=\"2pe53q\" data-start=\"3309\" data-end=\"3356\">SOMASES + Dashboards = Resultado profissional<\/h1><p data-start=\"3358\" data-end=\"3434\">Quem cria dashboards sabe que praticamente tudo depende de c\u00e1lculos r\u00e1pidos.<\/p><p data-start=\"3436\" data-end=\"3461\">O SOMASES pode alimentar:<\/p><ul data-start=\"3463\" data-end=\"3627\"><li data-section-id=\"ni6g6n\" data-start=\"3463\" data-end=\"3483\">Indicadores (KPIs)<\/li><li data-section-id=\"31g2ta\" data-start=\"3484\" data-end=\"3507\">Cart\u00f5es de resultados<\/li><li data-section-id=\"ghncc6\" data-start=\"3508\" data-end=\"3528\">Gr\u00e1ficos din\u00e2micos<\/li><li data-section-id=\"yynq82\" data-start=\"3529\" data-end=\"3550\">Pain\u00e9is financeiros<\/li><li data-section-id=\"1k0lqg4\" data-start=\"3551\" data-end=\"3569\">Dashboards de RH<\/li><li data-section-id=\"ockk6f\" data-start=\"3570\" data-end=\"3591\">Controle de estoque<\/li><li data-section-id=\"1xwln5f\" data-start=\"3592\" data-end=\"3608\">Fluxo de caixa<\/li><li data-section-id=\"pydv8w\" data-start=\"3609\" data-end=\"3627\">Gest\u00e3o comercial<\/li><\/ul><p data-start=\"3629\" data-end=\"3737\">\u00c9 por isso que muitos dashboards profissionais utilizam dezenas de f\u00f3rmulas SOMASES trabalhando em conjunto.<\/p><hr data-start=\"3739\" data-end=\"3742\" \/><h1 data-section-id=\"pia89a\" data-start=\"3744\" data-end=\"3773\">SOMASES ou Tabela Din\u00e2mica?<\/h1><p data-start=\"3775\" data-end=\"3805\">Essa \u00e9 uma d\u00favida muito comum.<\/p><p data-start=\"3807\" data-end=\"3828\">A resposta \u00e9 simples.<\/p><p data-start=\"3830\" data-end=\"3888\">A Tabela Din\u00e2mica \u00e9 excelente para an\u00e1lises explorat\u00f3rias.<\/p><p data-start=\"3890\" data-end=\"3962\">J\u00e1 o SOMASES \u00e9 perfeito quando voc\u00ea deseja criar dashboards autom\u00e1ticos.<\/p><p data-start=\"3964\" data-end=\"4102\">Enquanto a Tabela Din\u00e2mica exige atualiza\u00e7\u00f5es e configura\u00e7\u00f5es, o SOMASES atualiza os resultados automaticamente sempre que os dados mudam.<\/p><p data-start=\"4104\" data-end=\"4205\">Na pr\u00e1tica, muitos profissionais utilizam ambos em conjunto para aproveitar o melhor de cada recurso.<\/p>\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-e8c1da7 elementor-widget elementor-widget-text-editor\" data-id=\"e8c1da7\" data-element_type=\"widget\" data-e-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<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"sf8a3z\" data-start=\"5257\" data-end=\"5271\">Dica de ouro<\/h1><p data-start=\"5273\" data-end=\"5358\">Combine o <strong data-start=\"5283\" data-end=\"5294\">SOMASES<\/strong> com outras fun\u00e7\u00f5es para criar solu\u00e7\u00f5es ainda mais inteligentes:<\/p><ul data-start=\"5360\" data-end=\"5639\"><li data-section-id=\"1xfr0py\" data-start=\"5360\" data-end=\"5395\"><strong data-start=\"5362\" data-end=\"5368\">SE<\/strong> para decis\u00f5es autom\u00e1ticas.<\/li><li data-section-id=\"1mpxzl9\" data-start=\"5396\" data-end=\"5448\"><strong data-start=\"5398\" data-end=\"5407\">PROCX<\/strong> para localizar informa\u00e7\u00f5es relacionadas.<\/li><li data-section-id=\"c3p4bh\" data-start=\"5449\" data-end=\"5491\"><strong data-start=\"5451\" data-end=\"5462\">FILTRAR<\/strong> para criar listas din\u00e2micas.<\/li><li data-section-id=\"1wgssqn\" data-start=\"5492\" data-end=\"5541\"><strong data-start=\"5494\" data-end=\"5503\">\u00daNICO<\/strong> para gerar crit\u00e9rios automaticamente.<\/li><li data-section-id=\"mjbmcc\" data-start=\"5542\" data-end=\"5590\"><strong data-start=\"5544\" data-end=\"5551\">LET<\/strong> para deixar f\u00f3rmulas mais organizadas.<\/li><li data-section-id=\"dqlvb8\" data-start=\"5591\" data-end=\"5639\"><strong data-start=\"5593\" data-end=\"5603\">LAMBDA<\/strong> para reutilizar c\u00e1lculos complexos.<\/li><\/ul><p data-start=\"5641\" data-end=\"5733\">Essa combina\u00e7\u00e3o permite construir planilhas modernas, r\u00e1pidas e muito mais f\u00e1ceis de manter.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6dcca85 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"6dcca85\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-5001e56 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"5001e56\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0b95eb8 elementor-widget elementor-widget-text-editor\" data-id=\"0b95eb8\" data-element_type=\"widget\" data-e-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<h2 style=\"text-align: center;\"><span style=\"color: #ffffff;\">Tem uma d\u00favida de Excel?<\/span><\/h2><p style=\"text-align: center;\"><span style=\"color: #ffffff;\">Compartilhe sua experi\u00eancia nos coment\u00e1rios. F\u00f3rmulas, fun\u00e7\u00f5es, dashboards e erros do Excel fazem parte do dia a dia de quem trabalha com dados.<\/span><\/p><p style=\"text-align: center;\"><span style=\"color: #ffffff;\">Quem sabe a sua d\u00favida n\u00e3o vira o pr\u00f3ximo conte\u00fado?<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c0c2b4 elementor-widget elementor-widget-text-editor\" data-id=\"1c0c2b4\" data-element_type=\"widget\" data-e-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<h1 class=\"PDq2pG_selectionAnchorContainer\" data-section-id=\"1g4xr35\" data-start=\"5740\" data-end=\"5751\">Conclus\u00e3o<\/h1><p data-start=\"5753\" data-end=\"5999\">O <strong data-start=\"5755\" data-end=\"5766\">SOMASES<\/strong> vai muito al\u00e9m de uma simples fun\u00e7\u00e3o de soma. Ele \u00e9 uma ferramenta estrat\u00e9gica para quem deseja criar planilhas inteligentes, automatizar an\u00e1lises e desenvolver dashboards profissionais que entregam informa\u00e7\u00f5es precisas em segundos.<\/p><p data-start=\"6001\" data-end=\"6234\">Em um mercado cada vez mais orientado por dados, dominar essa fun\u00e7\u00e3o representa uma vantagem competitiva. Quanto mais cedo voc\u00ea incorporar o SOMASES ao seu dia a dia, mais tempo economizar\u00e1 e maior ser\u00e1 a qualidade das suas an\u00e1lises.<\/p><p data-start=\"6236\" data-end=\"6547\" data-is-last-node=\"\" data-is-only-node=\"\">A melhor forma de aprender \u00e9 praticando. Experimente aplicar o SOMASES em seus pr\u00f3prios relat\u00f3rios e descubra como uma \u00fanica fun\u00e7\u00e3o pode transformar a maneira como voc\u00ea trabalha com Excel. Quem domina essa ferramenta deixa de apenas preencher planilhas e passa a gerar informa\u00e7\u00f5es que realmente apoiam decis\u00f5es.<\/p>\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-2b4987b elementor-widget elementor-widget-image\" data-id=\"2b4987b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases-1024x576.jpg\" class=\"attachment-large size-large wp-image-8594\" alt=\"SOMASES: A Fun\u00e7\u00e3o Que Est\u00e1 Revolucionando a Forma de Analisar Dados\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases-1024x576.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases-300x169.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases-768x432.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases-150x85.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases-600x338.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\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-f6809c1 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"f6809c1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8d3b722 wpr-comment-reply-separate wpr-comment-reply-align-right elementor-widget elementor-widget-wpr-post-comments\" data-id=\"8d3b722\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-post-comments.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"wpr-comments-wrap\" id=\"comments\">\t<div id=\"respond\" class=\"comment-respond\">\n\t\t<h3 id=\"wpr-reply-title\" class=\"wpr-comment-reply-title\">Leave a Reply <small><a rel=\"nofollow\" id=\"cancel-comment-reply-link\" href=\"\/m\/wp-json\/wp\/v2\/posts\/8593#respond\" style=\"display:none;\">Cancelar resposta<\/a><\/small><\/h3><form action=\"https:\/\/fpw.com.br\/m\/wp-comments-post.php\" method=\"post\" id=\"wpr-comment-form\" class=\"wpr-comment-form wpr-cf-style-5\"><p class=\"comment-notes\"><span id=\"email-notes\">O seu endere\u00e7o de e-mail n\u00e3o ser\u00e1 publicado.<\/span> <span class=\"required-field-message\">Campos obrigat\u00f3rios s\u00e3o marcados com <span class=\"required\">*<\/span><\/span><\/p><div class=\"wpr-comment-form-text\"><label>Message<span>*<\/span><\/label><textarea autocomplete=\"new-password\"   name=\"ea4449d22c\"  placeholder=\"\" cols=\"45\" rows=\"8\" maxlength=\"65525\"><\/textarea><textarea id=\"comment\" aria-label=\"hp-comment\" aria-hidden=\"true\" name=\"comment\" autocomplete=\"new-password\" style=\"padding:0 !important;clip:rect(1px, 1px, 1px, 1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;\" tabindex=\"-1\"><\/textarea><\/div><p class=\"comment-form-author\"><input id=\"author\" class=\"comment-form__field\" name=\"author\" type=\"text\" placeholder=\"Nome *\" value=\"\" size=\"30\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-email\"><input id=\"email\" class=\"comment-form__field\" name=\"email\" type=\"text\" placeholder=\"E-mail *\" value=\"\" size=\"30\" aria-describedby=\"email-notes\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-url\"><input id=\"url\" class=\"comment-form__field\" name=\"url\" type=\"text\" placeholder=\"Site\" value=\"\" size=\"30\" \/><\/p>\n<p class=\"form-submit\"><input name=\"submit\" type=\"submit\" id=\"wpr-submit-comment\" class=\"wpr-submit-comment\" value=\"Submit\" \/> <input type='hidden' name='comment_post_ID' value='9992' id='comment_post_ID' \/>\n<input type='hidden' name='comment_parent' id='comment_parent' value='0' \/>\n<\/p><\/form>\t<\/div><!-- #respond -->\n\t<\/div>\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\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>&#8211; EXCEL \u2022 DICAS PR\u00c1TICAS &#8211; SOMASES no Excel A Fun\u00e7\u00e3o Que Est\u00e1 Revolucionando a Forma de Analisar Dados Em um cen\u00e1rio onde empresas geram milhares de registros diariamente, encontrar informa\u00e7\u00f5es espec\u00edficas deixou de ser um diferencial e passou a ser uma necessidade. Imagine responder perguntas como: Quanto foi vendido apenas na Regi\u00e3o Sul? Qual foi o faturamento do vendedor Jo\u00e3o no m\u00eas de junho? Quanto a empresa gastou apenas com o setor de Marketing? Qual o total de horas extras do turno noturno? Quanto foi pago apenas aos funcion\u00e1rios ativos? Tudo isso pode ser resolvido com apenas uma f\u00f3rmula. \u00c9 exatamente para isso que serve o SOMASES. All Posts Blog Certificados Dados Dashboard Diversos Excel FPw Membros Not\u00c3\u00adcias Planilhas Produtos SQL Tecnologia WordPress FPw | Onde encontrar cursos de FPw e LG Nuvem? Leia mais Dados | Sua empresa provavelmente n\u00e3o sofre de falta de dados. Leia mais Dashboard | 3 erros que fazem um Dashboard Financeiro parecer profissional \u2014 mas entregar decis\u00f5es ruins Leia mais O que \u00e9 a fun\u00e7\u00e3o SOMASES? A fun\u00e7\u00e3o SOMASES soma valores que atendem simultaneamente a v\u00e1rios crit\u00e9rios. Sua estrutura \u00e9 simples: \u00a0 =SOMASES(intervalo_soma; intervalo_crit\u00e9rio1; crit\u00e9rio1; intervalo_crit\u00e9rio2; crit\u00e9rio2&#8230;) \u00a0 Enquanto a fun\u00e7\u00e3o SOMASE trabalha com apenas uma condi\u00e7\u00e3o, o SOMASES permite utilizar dezenas de crit\u00e9rios ao mesmo tempo. Essa capacidade torna a fun\u00e7\u00e3o extremamente poderosa para an\u00e1lises profissionais. https:\/\/www.youtube.com\/watch?v=_AeEMfOlsEc Exemplo pr\u00e1tico Imagine a seguinte tabela: Vendedor Regi\u00e3o Produto Valor Jo\u00e3o Sul Notebook 3500 Jo\u00e3o Norte Monitor 1200 Ana Sul Notebook 4200 Jo\u00e3o Sul Impressora 900 Voc\u00ea deseja descobrir quanto Jo\u00e3o vendeu apenas na Regi\u00e3o Sul. A f\u00f3rmula seria: \u00a0 =SOMASES(D2:D5;A2:A5;&#8221;Jo\u00e3o&#8221;;B2:B5;&#8221;Sul&#8221;) \u00a0 Resultado: R$ 4.400 Sem filtros. Sem c\u00e1lculos manuais. Sem perder tempo. O grande segredo que poucos conhecem A maioria das pessoas utiliza o SOMASES apenas com textos. Mas \u00e9 poss\u00edvel combinar crit\u00e9rios utilizando: Datas N\u00fameros Per\u00edodos Compara\u00e7\u00f5es Refer\u00eancias de c\u00e9lulas Operadores matem\u00e1ticos Caracteres curingas Isso abre possibilidades praticamente ilimitadas. Gostaria de aprimorar seu conhecimento em Excel, aproveite nossos Cursos. Exemplos que impressionam Somar vendas acima de R$ 5.000 \u00a0 =SOMASES(D:D;D:D;&#8221;&gt;5000&#8243;) \u00a0 Somar apenas o m\u00eas de janeiro \u00a0 =SOMASES(D:D;A:A;&#8221;&gt;=01\/01\/2026&#8243;;A:A;&#8221;&lt;=31\/01\/2026&#8243;) \u00a0 Somar apenas produtos iniciados com &#8220;Note&#8221; \u00a0 =SOMASES(D:D;C:C;&#8221;Note*&#8221;) \u00a0 O asterisco (*) funciona como caractere curinga. Pouca gente utiliza esse recurso. SOMASES + Dashboards = Resultado profissional Quem cria dashboards sabe que praticamente tudo depende de c\u00e1lculos r\u00e1pidos. O SOMASES pode alimentar: Indicadores (KPIs) Cart\u00f5es de resultados Gr\u00e1ficos din\u00e2micos Pain\u00e9is financeiros Dashboards de RH Controle de estoque Fluxo de caixa Gest\u00e3o comercial \u00c9 por isso que muitos dashboards profissionais utilizam dezenas de f\u00f3rmulas SOMASES trabalhando em conjunto. SOMASES ou Tabela Din\u00e2mica? Essa \u00e9 uma d\u00favida muito comum. A resposta \u00e9 simples. A Tabela Din\u00e2mica \u00e9 excelente para an\u00e1lises explorat\u00f3rias. J\u00e1 o SOMASES \u00e9 perfeito quando voc\u00ea deseja criar dashboards autom\u00e1ticos. Enquanto a Tabela Din\u00e2mica exige atualiza\u00e7\u00f5es e configura\u00e7\u00f5es, o SOMASES atualiza os resultados automaticamente sempre que os dados mudam. Na pr\u00e1tica, muitos profissionais utilizam ambos em conjunto para aproveitar o melhor de cada recurso. Dica de ouro Combine o SOMASES com outras fun\u00e7\u00f5es para criar solu\u00e7\u00f5es ainda mais inteligentes: SE para decis\u00f5es autom\u00e1ticas. PROCX para localizar informa\u00e7\u00f5es relacionadas. FILTRAR para criar listas din\u00e2micas. \u00daNICO para gerar crit\u00e9rios automaticamente. LET para deixar f\u00f3rmulas mais organizadas. LAMBDA para reutilizar c\u00e1lculos complexos. Essa combina\u00e7\u00e3o permite construir planilhas modernas, r\u00e1pidas e muito mais f\u00e1ceis de manter. Tem uma d\u00favida de Excel? Compartilhe sua experi\u00eancia nos coment\u00e1rios. F\u00f3rmulas, fun\u00e7\u00f5es, dashboards e erros do Excel fazem parte do dia a dia de quem trabalha com dados. Quem sabe a sua d\u00favida n\u00e3o vira o pr\u00f3ximo conte\u00fado? Conclus\u00e3o O SOMASES vai muito al\u00e9m de uma simples fun\u00e7\u00e3o de soma. Ele \u00e9 uma ferramenta estrat\u00e9gica para quem deseja criar planilhas inteligentes, automatizar an\u00e1lises e desenvolver dashboards profissionais que entregam informa\u00e7\u00f5es precisas em segundos. Em um mercado cada vez mais orientado por dados, dominar essa fun\u00e7\u00e3o representa uma vantagem competitiva. Quanto mais cedo voc\u00ea incorporar o SOMASES ao seu dia a dia, mais tempo economizar\u00e1 e maior ser\u00e1 a qualidade das suas an\u00e1lises. A melhor forma de aprender \u00e9 praticando. Experimente aplicar o SOMASES em seus pr\u00f3prios relat\u00f3rios e descubra como uma \u00fanica fun\u00e7\u00e3o pode transformar a maneira como voc\u00ea trabalha com Excel. Quem domina essa ferramenta deixa de apenas preencher planilhas e passa a gerar informa\u00e7\u00f5es que realmente apoiam decis\u00f5es. 2 Comments Bulk Material Transfer25 de setembro de 2026 at 12:24 | Edit Everyone loves what you guys tend to be up too. Such clever work and reporting! Keep up the fantastic works guys I&#8217;ve included you guys to blogroll. Responder Silo Design25 de setembro de 2026 at 05:09 | Edit Hey there, I think your site might be having browser compatibility issues. When I look at your blog site in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, wonderful blog! Responder Leave a Reply Cancelar resposta Conectado como Marco Chinarelli. Edite seu perfil. Sair? Campos obrigat\u00f3rios s\u00e3o marcados com * Message*<\/p>\n","protected":false},"author":2000,"featured_media":8594,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3],"tags":[49,90,84,92,259,260,261,40,262,263,29,48,77,55,56,103,5,101,81,86,98,87,6,47,74,75,93],"class_list":["post-8593","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-aprenda-como-usar-no-excel-avancado","tag-aprenda-todas-as-possibilidades-de-formatacoes-no-excel","tag-como-desproteger-um-arquivo-do-excel-protegido-por-senha","tag-crie-um-sistema-de-sorteio-no-excel-de-forma-simples","tag-dashboard","tag-dashboard-financeiro","tag-dashboard-financeiro-pessoal","tag-dashboard-para-controle-financeiro","tag-dashboard-rh-controle-de-desligamentos","tag-dashboard-seguranca-do-trabalho","tag-excel","tag-formula-se-com-procv","tag-funcao-arrumar-com-alguns-truques","tag-funcoes-basicas-do-excel","tag-funcoes-basicas-operadores","tag-grafico-medidor-de-bateria","tag-menu-dados-completo","tag-montando-um-resumo-de-diversas-planilhas-com-somase","tag-planilha-de-controle-financeiro-tudo-o-que-voce-precisa-saber","tag-planilhas","tag-procv-junto-com-o-corresp","tag-protegendo-celulas","tag-saiba-tudo-da-parte-de-dados","tag-software-de-planilha-online-gratuito-excel-microsoft-365","tag-tudo-sobre-formatacao-de-celulas","tag-tudo-sobre-lista-suspensa-no-excel","tag-tudo-sobre-tabela-e-graficos-dinamicos"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/07\/somases.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/users\/2000"}],"replies":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/comments?post=8593"}],"version-history":[{"count":3,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8593\/revisions"}],"predecessor-version":[{"id":9894,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8593\/revisions\/9894"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/8594"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=8593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=8593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=8593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}