{"id":8444,"date":"2026-06-10T17:12:57","date_gmt":"2026-06-10T17:12:57","guid":{"rendered":"https:\/\/www.fpw.com.br\/?p=8444"},"modified":"2026-06-10T17:18:04","modified_gmt":"2026-06-10T17:18:04","slug":"excel-como-utilizar-formatacao-condicional-com-somase-e-cont-se","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/excel-como-utilizar-formatacao-condicional-com-somase-e-cont-se\/","title":{"rendered":"Excel | Como Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"8444\" class=\"elementor elementor-8444\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-76c1340 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=\"76c1340\" 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\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\">Como Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE<\/h2>\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<h2 data-start=\"149\" data-end=\"248\">\ud83d\udccaComo Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE no Excel<\/h2><p class=\"isSelectedEnd\">O Excel possui recursos extremamente poderosos para an\u00e1lise de dados, e um dos mais \u00fateis \u00e9 a <strong>Formata\u00e7\u00e3o Condicional<\/strong>. Quando combinada com fun\u00e7\u00f5es como <strong>SOMASE<\/strong> e <strong>CONT.SE<\/strong>, ela permite destacar automaticamente informa\u00e7\u00f5es importantes, facilitando a visualiza\u00e7\u00e3o de tend\u00eancias, exce\u00e7\u00f5es e indicadores relevantes.<\/p><p>Se voc\u00ea trabalha com vendas, financeiro, estoque, RH ou qualquer \u00e1rea que utilize planilhas, dominar essa t\u00e9cnica pode aumentar significativamente sua produtividade e a qualidade das suas an\u00e1lises.<\/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-ea8143d elementor-widget elementor-widget-heading\" data-id=\"ea8143d\" 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\">Adquira nossos produtos \u00e0 partir de R$ 5,00 e ajude-nos a continuar a trazer novos conte\u00fados relevantes<\/h2>\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-1fbf01b 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=\"1fbf01b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-9372d0e 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=\"9372d0e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-4333299 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=\"4333299\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2899411 elementor-widget elementor-widget-image\" data-id=\"2899411\" 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:\/\/pay.kiwify.com.br\/8bGr7UE\" 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\/2025\/07\/m-canva.png\" class=\"attachment-large size-large wp-image-8373\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-canva-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-84f8944 elementor-widget elementor-widget-image\" data-id=\"84f8944\" 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:\/\/shop.maisfy.com.br\/checkout\/Htc7yfd8\/Kbrpzup2?utm_source=Direto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=planilhas-controle-financeiro-dual&#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\/2025\/01\/m-financeira2.png\" class=\"attachment-large size-large wp-image-8354\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-financeira2-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-e1fdbb1 elementor-widget elementor-widget-image\" data-id=\"e1fdbb1\" 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:\/\/pay.kiwify.com.br\/ncKTGdo\" 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\/2025\/07\/m-fc.png\" class=\"attachment-large size-large wp-image-8377\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-fc-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-67a6ea1 elementor-widget elementor-widget-image\" data-id=\"67a6ea1\" 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:\/\/shop.maisfy.com.br\/checkout\/Tjvp3h33\/Q8zra5d6\" 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-a4d5354 elementor-widget elementor-widget-image\" data-id=\"a4d5354\" 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:\/\/shop.maisfy.com.br\/checkout\/C433xjc5\/Mdv632r4\" 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\/m15.png\" class=\"attachment-large size-large wp-image-8383\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m15-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>\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<h2>O que \u00e9 Formata\u00e7\u00e3o Condicional?<\/h2><p class=\"isSelectedEnd\">A Formata\u00e7\u00e3o Condicional \u00e9 um recurso que altera automaticamente a apar\u00eancia das c\u00e9lulas quando determinadas condi\u00e7\u00f5es s\u00e3o atendidas.<\/p><p class=\"isSelectedEnd\">Voc\u00ea pode, por exemplo:<\/p><ul data-spread=\"false\"><li>Destacar valores acima de uma meta.<\/li><li>Identificar clientes com maior volume de compras.<\/li><li>Localizar produtos com baixo estoque.<\/li><li>Evidenciar registros duplicados.<\/li><li>Destacar vendedores com maior desempenho.<\/li><\/ul><p>Tudo isso acontece automaticamente conforme os dados s\u00e3o atualizados.<\/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=GAoYCqgoyVE&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<h2>Utilizando SOMASE na Formata\u00e7\u00e3o Condicional<\/h2><p class=\"isSelectedEnd\">A fun\u00e7\u00e3o SOMASE permite somar valores que atendem a um determinado crit\u00e9rio.<\/p><h3>Exemplo<\/h3><p class=\"isSelectedEnd\">Imagine uma tabela de vendas onde voc\u00ea deseja destacar produtos cuja soma das vendas seja superior a R$ 10.000.<\/p><p class=\"isSelectedEnd\">A regra pode utilizar uma f\u00f3rmula semelhante a:<\/p><p class=\"isSelectedEnd\">=SOMASE($C:$C;C2;$D:$D)&gt;=10000<\/p><p class=\"isSelectedEnd\">Nesse exemplo:<\/p><ul data-spread=\"false\"><li>A coluna C cont\u00e9m os produtos.<\/li><li>A coluna D cont\u00e9m os valores das vendas.<\/li><li>O Excel soma todas as vendas do produto selecionado.<\/li><li>Se o resultado for maior ou igual a R$ 10.000, a linha recebe destaque automaticamente.<\/li><\/ul>\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-4ba9308 elementor-widget elementor-widget-heading\" data-id=\"4ba9308\" 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<h4 class=\"elementor-heading-title elementor-size-default\">Que tal aproveitar as ofertas exclusivas dos nossos cursos online?<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0defca7 elementor-widget elementor-widget-text-editor\" data-id=\"0defca7\" 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<p>OBS. Os valores podem sofre altera\u00e7\u00f5es sem aviso pr\u00e9vio! Clique sobre a imagem para acessar a oferta.<\/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-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-0d697c8 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=\"0d697c8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-dcb4061 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=\"dcb4061\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9db341e elementor-widget elementor-widget-image\" data-id=\"9db341e\" 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:\/\/pay.kiwify.com.br\/8bGr7UE\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva.png\" class=\"attachment-large size-large wp-image-7976\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva.png 720w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-300x300.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-230x230.png 230w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-400x400.png 400w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-600x600.png 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/canva-640x640.png 640w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/>\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-14d6d2a elementor-widget elementor-widget-image\" data-id=\"14d6d2a\" 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:\/\/pay.kiwify.com.br\/ncKTGdo\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc.png\" class=\"attachment-large size-large wp-image-7979\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc.png 720w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-300x300.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-230x230.png 230w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-400x400.png 400w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-600x600.png 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/fc-640x640.png 640w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/>\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-efc494c elementor-widget elementor-widget-image\" data-id=\"efc494c\" 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:\/\/pay.kiwify.com.br\/BUhjO61\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-1024x1024.jpg\" class=\"attachment-large size-large wp-image-7980\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-1024x1024.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-300x300.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-150x150.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-768x768.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-230x230.jpg 230w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-400x400.jpg 400w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-600x600.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1-640x640.jpg 640w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/dash-expert1.jpg 1125w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\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>\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<h3>Benef\u00edcios<\/h3><ul data-spread=\"false\"><li>Identifica\u00e7\u00e3o r\u00e1pida dos produtos mais vendidos.<\/li><li>Monitoramento de metas.<\/li><li>An\u00e1lises visuais mais eficientes.<\/li><li>Atualiza\u00e7\u00e3o autom\u00e1tica conforme novos dados s\u00e3o inseridos.<\/li><\/ul><h2>Utilizando CONT.SE na Formata\u00e7\u00e3o Condicional<\/h2><p class=\"isSelectedEnd\">A fun\u00e7\u00e3o CONT.SE conta quantas vezes um determinado crit\u00e9rio aparece em um intervalo.<\/p><h3>Exemplo<\/h3><p class=\"isSelectedEnd\">Suponha que voc\u00ea queira destacar vendedores que realizaram tr\u00eas ou mais vendas.<\/p><p class=\"isSelectedEnd\">A f\u00f3rmula utilizada pode ser:<\/p><p class=\"isSelectedEnd\">=CONT.SE($B:$B;B2)&gt;=3<\/p><p class=\"isSelectedEnd\">Nesse cen\u00e1rio:<\/p><ul data-spread=\"false\"><li>A coluna B cont\u00e9m os nomes dos vendedores.<\/li><li>O Excel conta quantas vezes cada vendedor aparece.<\/li><li>Quando o n\u00famero de ocorr\u00eancias for igual ou superior a tr\u00eas, o destaque \u00e9 aplicado automaticamente.<\/li><\/ul><h3>Aplica\u00e7\u00f5es Pr\u00e1ticas<\/h3><ul data-spread=\"false\"><li>Identifica\u00e7\u00e3o de clientes recorrentes.<\/li><li>Controle de frequ\u00eancia.<\/li><li>An\u00e1lise de produtividade.<\/li><li>Monitoramento de ocorr\u00eancias e chamados.<\/li><\/ul>\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-b7af720 elementor-widget elementor-widget-image\" data-id=\"b7af720\" 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:\/\/api.whatsapp.com\/send\/?phone=5511968986914&#038;text=Gostaria+de+saber+como+fa%C3%A7o+para+ter+minha+marca+divulgada+em+seu+site%3F&#038;type=phone_number&#038;app_absent=0&#038;utm_source=Direto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=x&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1022\" height=\"186\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902.jpg\" class=\"attachment-large size-large wp-image-7970\" alt=\"sua marca aqui\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902.jpg 1022w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902-300x55.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902-768x140.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/01\/sua-marca-aqui-e1768828172902-600x109.jpg 600w\" sizes=\"(max-width: 1022px) 100vw, 1022px\" \/>\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-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<h2>Combinando SOMASE e CONT.SE<\/h2><p class=\"isSelectedEnd\">O verdadeiro poder surge quando essas fun\u00e7\u00f5es s\u00e3o utilizadas em conjunto.<\/p><p class=\"isSelectedEnd\">Por exemplo:<\/p><ul data-spread=\"false\"><li>Destacar vendedores que realizaram mais de tr\u00eas vendas e ultrapassaram uma determinada meta.<\/li><li>Identificar produtos com alta frequ\u00eancia de vendas e maior faturamento.<\/li><li>Monitorar indicadores de desempenho automaticamente.<\/li><\/ul><p class=\"isSelectedEnd\">Essa combina\u00e7\u00e3o transforma uma planilha simples em uma poderosa ferramenta de an\u00e1lise gerencial.<\/p><h2>Vantagens para Profissionais de Excel<\/h2><p class=\"isSelectedEnd\">Ao dominar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE voc\u00ea consegue:<\/p><p class=\"isSelectedEnd\">\u2705 Criar relat\u00f3rios mais inteligentes<\/p><p class=\"isSelectedEnd\">\u2705 Reduzir an\u00e1lises manuais<\/p><p class=\"isSelectedEnd\">\u2705 Destacar informa\u00e7\u00f5es cr\u00edticas automaticamente<\/p><p class=\"isSelectedEnd\">\u2705 Melhorar a tomada de decis\u00e3o<\/p><p class=\"isSelectedEnd\">\u2705 Construir dashboards mais profissionais<\/p><p>\u2705 Economizar tempo em tarefas repetitivas<\/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-68f3c5c 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=\"68f3c5c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-599927c elementor-widget elementor-widget-heading\" data-id=\"599927c\" 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<h4 class=\"elementor-heading-title elementor-size-default\">Conhe\u00e7am nossos pacotes de Dashboards<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d17c751 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=\"d17c751\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-652ab5f 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=\"652ab5f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-86798dd elementor-widget elementor-widget-image\" data-id=\"86798dd\" 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:\/\/shop.maisfy.com.br\/checkout\/Z6kmgtk2\/Yh6egwp4\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"903\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000.png\" class=\"attachment-large size-large wp-image-7843\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000.png 621w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000-206x300.png 206w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-1000-600x872.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/>\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-65ca8f7 elementor-widget elementor-widget-image\" data-id=\"65ca8f7\" 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:\/\/pay.kiwify.com.br\/Tv5opMh\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"903\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150.png\" class=\"attachment-large size-large wp-image-7844\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150.png 621w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150-206x300.png 206w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-150-600x872.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/>\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-aae76c5 elementor-widget elementor-widget-image\" data-id=\"aae76c5\" 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:\/\/shop.maisfy.com.br\/checkout\/Uvsnz837\/Kgapf219\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"903\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400.png\" class=\"attachment-large size-large wp-image-7845\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400.png 621w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400-206x300.png 206w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/12\/CAIXA-400-600x872.png 600w\" sizes=\"(max-width: 621px) 100vw, 621px\" \/>\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>\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<h2>Conclus\u00e3o<\/h2><p class=\"isSelectedEnd\">A combina\u00e7\u00e3o entre Formata\u00e7\u00e3o Condicional, SOMASE e CONT.SE \u00e9 uma das t\u00e9cnicas mais \u00fateis para quem deseja elevar o n\u00edvel das an\u00e1lises no Excel. Com poucos cliques e f\u00f3rmulas simples, \u00e9 poss\u00edvel transformar grandes volumes de dados em informa\u00e7\u00f5es visuais f\u00e1ceis de interpretar.<\/p><p>Se voc\u00ea deseja criar planilhas mais inteligentes, automatizadas e profissionais, essa \u00e9 uma habilidade que vale a pena dominar.<\/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\/06\/format-1024x576.jpg\" class=\"attachment-large size-large wp-image-8445\" alt=\"Como Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/format-1024x576.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/format-300x169.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/format-768x432.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/format-150x85.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/format-600x338.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/06\/format.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<div class=\"elementor-element elementor-element-c4ea7cd 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=\"c4ea7cd\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db7938c wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"db7938c\" 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\",\"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;:113,&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-9253 post type-post status-publish format-standard has-post-thumbnail hentry category-excel\"><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\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.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\/09\/Erros-do-Excel-qual-a-diferenca-entre-ND-REF-e-os-outros-erros.jpg\" alt=\"Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros\" 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\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\"><\/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\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros?<\/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\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\" 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-9168 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\"><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\/09\/Excel-Como-corrigir-o-erro-ND-no-Excel.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\/09\/Excel-Como-corrigir-o-erro-ND-no-Excel.jpg\" alt=\"Como corrigir o erro #N\/D no Excel?\" 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\/excel-como-corrigir-o-erro-n-d-no-excel\/\"><\/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\/excel-como-corrigir-o-erro-n-d-no-excel\/\">Excel | Como corrigir o erro #N\/D no Excel?<\/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\/excel-como-corrigir-o-erro-n-d-no-excel\/\" 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-9018 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-o-que-e-fpw-on-prime 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\/09\/fpw-Por-que-o-FPw-e-o-LG-Nuvem-sao-referencias-em-Folha-de-Pagamento-no-Brasil.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\/09\/fpw-Por-que-o-FPw-e-o-LG-Nuvem-sao-referencias-em-Folha-de-Pagamento-no-Brasil.jpg\" alt=\"Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil\" 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-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\"><\/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-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\">FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil?<\/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-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/\" 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 class=\"elementor-element elementor-element-0e421c9 elementor-search-form--skin-classic elementor-search-form--button-type-icon elementor-search-form--icon-search elementor-widget elementor-widget-search-form\" data-id=\"0e421c9\" 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-0e421c9\">Search<\/label>\n\n\t\t\t\t\t\n\t\t\t\t\t<input id=\"elementor-search-form-0e421c9\" 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 class=\"elementor-element elementor-element-73e0cad elementor-widget elementor-widget-image\" data-id=\"73e0cad\" 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:\/\/pay.kiwify.com.br\/k8pQpys\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"480\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/09\/dash-oferta.jpg\" class=\"attachment-large size-large wp-image-7443\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/09\/dash-oferta.jpg 320w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/09\/dash-oferta-200x300.jpg 200w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/>\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-dfe196e elementor-widget elementor-widget-image\" data-id=\"dfe196e\" 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:\/\/shop.maisfy.com.br\/checkout\/Zww7rrr4\/Hi8hxk47\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"320\" height=\"480\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/precificacao.jpg\" class=\"attachment-large size-large wp-image-8204\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/precificacao.jpg 320w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/precificacao-200x300.jpg 200w\" sizes=\"(max-width: 320px) 100vw, 320px\" \/>\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-9418cd9 elementor-widget elementor-widget-image\" data-id=\"9418cd9\" 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:\/\/shop.maisfy.com.br\/checkout\/Gjplwgr4\/Kk18fkp5\" 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\/01\/m-planilnha-premium.png\" class=\"attachment-large size-large wp-image-8323\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/m-planilnha-premium-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-4e0f208 elementor-widget elementor-widget-link-in-bio\" data-id=\"4e0f208\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"link-in-bio.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio e-link-in-bio\">\n\t\t\t<div class=\"e-link-in-bio__content\">\n\n\t\t\t\t\t\t<div class=\"e-link-in-bio__identity\">\n\t\t\t\t\t\t\t\t\t<div class=\"e-link-in-bio__identity-image e-link-in-bio__identity-image-profile has-style-circle\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"291\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli-300x291.png\" class=\"e-link-in-bio__identity-image-element\" alt=\"Marco Antonio Chinarelli\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli-300x291.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/02\/foto-chinarelli.png 386w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"e-link-in-bio__bio\">\n\t\t\t\t<h3 class=\"e-link-in-bio__heading\">Marco Chinarelli<\/h3>\t\t\t\t<h3 class=\"e-link-in-bio__title\">Especialista e Professor em Excel, pacote Office e Sistema de Folha de Pagamento<\/h3>\t\t\t\t\t\t\t\t<p class=\"e-link-in-bio__description\">Junte-se a n\u00f3s nesta Jornada pelo Mundo da Tecnologia recheada de Excel<\/p>\t\t\t<\/div>\n\t\t\t\t\t<div class=\"e-link-in-bio__icons has-size-small\">\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/chinarelliti\/\" target=\"_blank\" rel=\"noopener \" aria-label=\"LinkedIn\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin-in\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.instagram.com\/marco_chinarelli\" target=\"_blank\" rel=\"noopener \" aria-label=\"Instagram\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-instagram\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M224.1 141c-63.6 0-114.9 51.3-114.9 114.9s51.3 114.9 114.9 114.9S339 319.5 339 255.9 287.7 141 224.1 141zm0 189.6c-41.1 0-74.7-33.5-74.7-74.7s33.5-74.7 74.7-74.7 74.7 33.5 74.7 74.7-33.6 74.7-74.7 74.7zm146.4-194.3c0 14.9-12 26.8-26.8 26.8-14.9 0-26.8-12-26.8-26.8s12-26.8 26.8-26.8 26.8 12 26.8 26.8zm76.1 27.2c-1.7-35.9-9.9-67.7-36.2-93.9-26.2-26.2-58-34.4-93.9-36.2-37-2.1-147.9-2.1-184.9 0-35.8 1.7-67.6 9.9-93.9 36.1s-34.4 58-36.2 93.9c-2.1 37-2.1 147.9 0 184.9 1.7 35.9 9.9 67.7 36.2 93.9s58 34.4 93.9 36.2c37 2.1 147.9 2.1 184.9 0 35.9-1.7 67.7-9.9 93.9-36.2 26.2-26.2 34.4-58 36.2-93.9 2.1-37 2.1-147.8 0-184.8zM398.8 388c-7.8 19.6-22.9 34.7-42.6 42.6-29.5 11.7-99.5 9-132.1 9s-102.7 2.6-132.1-9c-19.6-7.8-34.7-22.9-42.6-42.6-11.7-29.5-9-99.5-9-132.1s-2.6-102.7 9-132.1c7.8-19.6 22.9-34.7 42.6-42.6 29.5-11.7 99.5-9 132.1-9s102.7-2.6 132.1 9c19.6 7.8 34.7 22.9 42.6 42.6 11.7 29.5 9 99.5 9 132.1s2.7 102.7-9 132.1z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/www.youtube.com\/@dashimpressionador\" target=\"_blank\" rel=\"noopener \" aria-label=\"YouTube\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-youtube\" viewBox=\"0 0 576 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M549.655 124.083c-6.281-23.65-24.787-42.276-48.284-48.597C458.781 64 288 64 288 64S117.22 64 74.629 75.486c-23.497 6.322-42.003 24.947-48.284 48.597-11.412 42.867-11.412 132.305-11.412 132.305s0 89.438 11.412 132.305c6.281 23.65 24.787 41.5 48.284 47.821C117.22 448 288 448 288 448s170.78 0 213.371-11.486c23.497-6.321 42.003-24.171 48.284-47.821 11.412-42.867 11.412-132.305 11.412-132.305s0-89.438-11.412-132.305zm-317.51 213.508V175.185l142.739 81.205-142.739 81.201z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"e-link-in-bio__icon is-size-small\">\n\t\t\t\t\t<a href=\"https:\/\/twitter.com\/mchinarelli\" target=\"_blank\" rel=\"noopener \" aria-label=\"X (Twitter)\" class=\"e-link-in-bio__icon-link\">\n\t\t\t\t\t\t<span class=\"e-link-in-bio__icon-svg\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-x-twitter\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\n\t\t<div class=\"e-link-in-bio__ctas has-type-button\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/pay.hotmart.com\/G98229179R?off=ru4d1ctf&#038;bid=1747747718132\" target=\"_blank\" rel=\"noopener \" class=\"e-link-in-bio__cta is-type-button has-corners-rounded\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"e-link-in-bio__cta-text\">\n\t\t\t\t\t\tCurso Excel Total Promo\u00e7\u00e3o\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\t\t\t<a href=\"https:\/\/fpw.com.br\/m\/produtos-curso-de-dashboard\/\" target=\"_blank\" rel=\"noopener \" class=\"e-link-in-bio__cta is-type-button has-corners-rounded\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"e-link-in-bio__cta-text\">\n\t\t\t\t\t\tCurso Do Zero ao Dashboard\t\t\t\t\t<\/span>\n\t\t\t\t<\/a>\n\t\t\t\t\t<\/div>\n\t\t\n\t\t\t<\/div>\n\t\t\t<div class=\"e-link-in-bio__bg\">\n\t\t\t\t<div class=\"e-link-in-bio__bg-overlay\"><\/div>\n\t\t\t<\/div>\n\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-3f8d714 elementor-widget elementor-widget-image\" data-id=\"3f8d714\" 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:\/\/shop.maisfy.com.br\/checkout\/Vye79iq6\/Z9nnhh91\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"394\" height=\"506\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/pb2.png\" class=\"attachment-large size-large wp-image-8312\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/pb2.png 394w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2024\/10\/pb2-234x300.png 234w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/>\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-42fc103 elementor-widget elementor-widget-image\" data-id=\"42fc103\" 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:\/\/shop.maisfy.com.br\/checkout\/Mx31hue3\/Bp4icrc3\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"636\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-sst.png\" class=\"attachment-large size-large wp-image-8180\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-sst.png 458w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-sst-216x300.png 216w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/>\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-d333768 elementor-widget elementor-widget-image\" data-id=\"d333768\" 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:\/\/shop.maisfy.com.br\/checkout\/Yjhhihn5\/M9quupr6\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"458\" height=\"636\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-rh.png\" class=\"attachment-large size-large wp-image-8179\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-rh.png 458w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/01\/pacote-completo-rh-216x300.png 216w\" sizes=\"(max-width: 458px) 100vw, 458px\" \/>\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\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\"><h3> 3 Comments<\/h3><ul class=\"wpr-comments-list\"><li id=\"comment-171556\" class=\"pingback even thread-even depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-botoes-interativos-no-excel\/\">Excel | Bot\u00f5es interativos no Excel &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>21 de setembro de 2026 at 22:50<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/?replytocom=171556#respond\" data-commentid=\"171556\" data-postid=\"9018\" data-belowelement=\"comment-171556\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Bot\u00f5es interativos no Excel &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Bot\u00f5es interativos no Excel &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171555\" class=\"pingback odd alt thread-odd thread-alt depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>20 de setembro de 2026 at 14:59<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Por que o FPw e o LG Nuvem s\u00e3o refer\u00eancias em Folha de Pagamento no Brasil? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/?replytocom=171555#respond\" data-commentid=\"171555\" data-postid=\"9018\" data-belowelement=\"comment-171555\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171553\" class=\"pingback even thread-even depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-como-corrigir-o-erro-n-d-no-excel\/\">Excel | Como corrigir o erro #N\/D no Excel? &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>16 de setembro de 2026 at 13:59<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Por que o FPw e o LG Nuvem s\u00c3\u00a3o refer\u00c3\u00aancias em Folha de Pagamento no Brasil? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-por-que-o-fpw-e-o-lg-nuvem-sao-referencias-em-folha-de-pagamento-no-brasil\/?replytocom=171553#respond\" data-commentid=\"171553\" data-postid=\"9018\" data-belowelement=\"comment-171553\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Como corrigir o erro #N\/D no Excel? &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Como corrigir o erro #N\/D no Excel? &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<\/ul>\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\/8444#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='9018' 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>Como Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE \ud83d\udccaComo Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE no Excel O Excel possui recursos extremamente poderosos para an\u00e1lise de dados, e um dos mais \u00fateis \u00e9 a Formata\u00e7\u00e3o Condicional. Quando combinada com fun\u00e7\u00f5es como SOMASE e CONT.SE, ela permite destacar automaticamente informa\u00e7\u00f5es importantes, facilitando a visualiza\u00e7\u00e3o de tend\u00eancias, exce\u00e7\u00f5es e indicadores relevantes. Se voc\u00ea trabalha com vendas, financeiro, estoque, RH ou qualquer \u00e1rea que utilize planilhas, dominar essa t\u00e9cnica pode aumentar significativamente sua produtividade e a qualidade das suas an\u00e1lises. Adquira nossos produtos \u00e0 partir de R$ 5,00 e ajude-nos a continuar a trazer novos conte\u00fados relevantes O que \u00e9 Formata\u00e7\u00e3o Condicional? A Formata\u00e7\u00e3o Condicional \u00e9 um recurso que altera automaticamente a apar\u00eancia das c\u00e9lulas quando determinadas condi\u00e7\u00f5es s\u00e3o atendidas. Voc\u00ea pode, por exemplo: Destacar valores acima de uma meta. Identificar clientes com maior volume de compras. Localizar produtos com baixo estoque. Evidenciar registros duplicados. Destacar vendedores com maior desempenho. Tudo isso acontece automaticamente conforme os dados s\u00e3o atualizados. https:\/\/www.youtube.com\/watch?v=GAoYCqgoyVE Utilizando SOMASE na Formata\u00e7\u00e3o Condicional A fun\u00e7\u00e3o SOMASE permite somar valores que atendem a um determinado crit\u00e9rio. Exemplo Imagine uma tabela de vendas onde voc\u00ea deseja destacar produtos cuja soma das vendas seja superior a R$ 10.000. A regra pode utilizar uma f\u00f3rmula semelhante a: =SOMASE($C:$C;C2;$D:$D)&gt;=10000 Nesse exemplo: A coluna C cont\u00e9m os produtos. A coluna D cont\u00e9m os valores das vendas. O Excel soma todas as vendas do produto selecionado. Se o resultado for maior ou igual a R$ 10.000, a linha recebe destaque automaticamente. Que tal aproveitar as ofertas exclusivas dos nossos cursos online? OBS. Os valores podem sofre altera\u00e7\u00f5es sem aviso pr\u00e9vio! Clique sobre a imagem para acessar a oferta. Benef\u00edcios Identifica\u00e7\u00e3o r\u00e1pida dos produtos mais vendidos. Monitoramento de metas. An\u00e1lises visuais mais eficientes. Atualiza\u00e7\u00e3o autom\u00e1tica conforme novos dados s\u00e3o inseridos. Utilizando CONT.SE na Formata\u00e7\u00e3o Condicional A fun\u00e7\u00e3o CONT.SE conta quantas vezes um determinado crit\u00e9rio aparece em um intervalo. Exemplo Suponha que voc\u00ea queira destacar vendedores que realizaram tr\u00eas ou mais vendas. A f\u00f3rmula utilizada pode ser: =CONT.SE($B:$B;B2)&gt;=3 Nesse cen\u00e1rio: A coluna B cont\u00e9m os nomes dos vendedores. O Excel conta quantas vezes cada vendedor aparece. Quando o n\u00famero de ocorr\u00eancias for igual ou superior a tr\u00eas, o destaque \u00e9 aplicado automaticamente. Aplica\u00e7\u00f5es Pr\u00e1ticas Identifica\u00e7\u00e3o de clientes recorrentes. Controle de frequ\u00eancia. An\u00e1lise de produtividade. Monitoramento de ocorr\u00eancias e chamados. Combinando SOMASE e CONT.SE O verdadeiro poder surge quando essas fun\u00e7\u00f5es s\u00e3o utilizadas em conjunto. Por exemplo: Destacar vendedores que realizaram mais de tr\u00eas vendas e ultrapassaram uma determinada meta. Identificar produtos com alta frequ\u00eancia de vendas e maior faturamento. Monitorar indicadores de desempenho automaticamente. Essa combina\u00e7\u00e3o transforma uma planilha simples em uma poderosa ferramenta de an\u00e1lise gerencial. Vantagens para Profissionais de Excel Ao dominar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE voc\u00ea consegue: \u2705 Criar relat\u00f3rios mais inteligentes \u2705 Reduzir an\u00e1lises manuais \u2705 Destacar informa\u00e7\u00f5es cr\u00edticas automaticamente \u2705 Melhorar a tomada de decis\u00e3o \u2705 Construir dashboards mais profissionais \u2705 Economizar tempo em tarefas repetitivas Conhe\u00e7am nossos pacotes de Dashboards Conclus\u00e3o A combina\u00e7\u00e3o entre Formata\u00e7\u00e3o Condicional, SOMASE e CONT.SE \u00e9 uma das t\u00e9cnicas mais \u00fateis para quem deseja elevar o n\u00edvel das an\u00e1lises no Excel. Com poucos cliques e f\u00f3rmulas simples, \u00e9 poss\u00edvel transformar grandes volumes de dados em informa\u00e7\u00f5es visuais f\u00e1ceis de interpretar. Se voc\u00ea deseja criar planilhas mais inteligentes, automatizadas e profissionais, essa \u00e9 uma habilidade que vale a pena dominar. All Posts Blog Certificados Diversos Excel FPw Membros Not\u00edcias Planilhas Produtos SQL Tecnologia WordPress Excel | Como Utilizar Formata\u00e7\u00e3o Condicional com SOMASE e CONT.SE Leia mais Excel | Como Desbloquear um Arquivo Protegido por Senha Leia mais Excel | Fun\u00e7\u00e3o INDIRETA Leia mais Marco Chinarelli Especialista e Professor em Excel, pacote Office e Sistema de Folha de Pagamento Junte-se a n\u00f3s nesta Jornada pelo Mundo da Tecnologia recheada de Excel Curso Excel Total Promo\u00e7\u00e3o Curso Do Zero ao Dashboard 1 Comment Excel | Como Desbloquear um Arquivo Protegido por Senha &#8211; Chinarelli TI Consultoria8 de junho de 2026 at 12:51 | Edit [&#8230;] Excel | Fun\u00e7\u00e3o INDIRETA [&#8230;] 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":8445,"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-8444","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\/06\/format.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8444","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=8444"}],"version-history":[{"count":0,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/8444\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/8445"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=8444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=8444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=8444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}