{"id":58927,"date":"2024-07-23T15:30:56","date_gmt":"2024-07-23T21:30:56","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=58927"},"modified":"2025-03-15T13:21:54","modified_gmt":"2025-03-15T19:21:54","slug":"formulas-de-excel-para-contadores","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/formulas-de-excel-para-contadores.html","title":{"rendered":"Formulas de excel para contadores"},"content":{"rendered":"<h1 id=\"t-1721685292048\">9 Impresionantes formulas de excel para contadores<\/h1>\n<p style=\"\">En la actualidad todo contador trabaja con excel o bien con las hojas de calculo de google para crear los informes financieros.<\/p>\n<p style=\"\">Es importante que tu como contador domines las 9 <em><strong>formulas de excel para contadores<\/strong><\/em> y las aplicaques en tus labores diarios.<\/p>\n<p style=\"\">Hola soy Roger Perez y estoy feliz de compartirte estas 9 maravillas de formulas para ti como contador.<\/p>\n<p style=\"\">Entonces veamos:<\/p>\n<h2 id=\"t-1721685292038\">Cuales son estas formulas de excel para contadores?<\/h2>\n<p style=\"\">A continuacion voy a compartirte la lista de <em><strong>formulas de excel para contadores<\/strong><\/em>, en total en este curso basico, te compartire 9 funciones especificas:<\/p>\n<ul>\n<li><span>La Funcion \u00abSUMAR.SI\u00bb &#8211; &gt;&gt; <a href=\"#1\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>La funcion \u00abSUMAR.SI.CONJUNTO\u00bb &#8211; &gt;&gt; <a href=\"#2\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>Funcion logica \u00abSI\u00bb &#8211; &gt;&gt; <a href=\"#3\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>La funcion \u00abSI.CONJUNTO\u00bb &#8211; &gt;&gt; <a href=\"#4\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>La funcion \u00abSUMAPRODUCTO\u00bb &#8211; &gt;&gt; <a href=\"#5\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>Funcion \u00abCOINCIDIRX\u00bb &#8211; &gt;&gt; <a href=\"#6\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>Funcion \u00abBUSCARV\u00bb &#8211; &gt;&gt; <a href=\"#7\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>La funcion \u00abBUSCARX\u00bb &#8211; &gt;&gt; <a href=\"#8\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li>\n<li><span>La Funcion \u00abFILTRAR\u00bb &#8211; &nbsp;&gt;&gt; <a href=\"#9\" style=\"outline: none;\">Clic aqui para mas detalle <\/a>&lt;&lt;.<\/span><\/li>\n<\/ul>\n<p style=\"\">Ahora que ya conoces la lista de las funciones que debes de manejar en las formulas de excel para contadores, voy a compartirte los detalles de como utilizar estas funciones:<\/p>\n<h3 id=\"t-1721685292039\">Primera funcion: Como utilizar la funcion SUMAR.SI<\/h3>\n<p style=\"\">La funcion SUMAR.SI es la primera funcion en la lista de formulas de excel para contadores:<\/p>\n<p style=\"\">Para iniciar, siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a ver la sintaxis:<\/p>\n<blockquote style=\"\"><p>=SUMAR.SI(El Rango del criterio; Criterio; el Rango que quieres Sumar )<\/p><\/blockquote>\n<p style=\"\">En forma de ejemplo solo para comprender la sintaxis:<\/p>\n<blockquote style=\"\"><p>= SUMAR.SI( Rango de Productos; \u00abCementos\u00bb; Ventas)<\/p><\/blockquote>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-sumar-si.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"620\" height=\"162\" data-init-height=\"162\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/11\/Formula-Excel-SUMAR-SI-SUMAR.SI_.png.webp\" data-width=\"620\" data-height=\"162\" style=\"aspect-ratio: auto 620 \/ 162;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<h3 id=\"t-1721685292040\">Segunda funcion: Como utilizar la funcion SUMAR.SI.CONJUNTO<\/h3>\n<p>La funcion SUMAR.SI.CONJUNTO es la segunda funcion en la lista de formulas de excel para contadores:<\/p>\n<p>Alguna vez has o\u00eddo hablar a miles de directivos de todo el mundo decir&#8230;\u00bb\u00bfCu\u00e1ntas ventas x &nbsp;hicimos en la regi\u00f3n A, del producto B, tipo de cliente C en el mes M?\u00bb &nbsp;Como responder\u00edas en ese mismo momento si la pregunta es para ti?<\/p>\n<p>Como responder\u00edas a la Pregunta sin usar excesivas filtraciones y selecciones de celdas en Excel?<\/p>\n<p style=\"\">Para responder a estas pregunta lo primero es lo primero, debes de conocer primero la sintaxis:<\/p>\n<blockquote><p>= SUMAR.SI.CONJUNTO (lo que quieres sumar, columna condici\u00f3n 1, condici\u00f3n, condiciones columna 2, Estado &#8230;.)<\/p><\/blockquote>\n<p>Ejemplo:<\/p>\n<blockquote><p>= SUMAR.SI.CONJUNTO (ventas, regiones, \u00abA\u00bb, los productos, \u00abB\u00bb, tipos de clientes, \u00abC\u00bb, el mes, \u00abM\u00bb)<\/p><\/blockquote>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el ejemplo explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-las-formulas-excel-sumar-si-conjunto.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292041\">Tercera funcion: Como utilizar la funcion logica SI<\/h3>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"532\" height=\"411\" data-init-height=\"353\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/01\/Aumento-de-Salario-Formula-Excel-SI-1.png.webp\" data-width=\"620\" data-height=\"411\" style=\"aspect-ratio: auto 532 \/ 353;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<p style=\"\">La funcion logica SI es la tercer funcion en la lista de formulas de excel para contadores:<\/p>\n<p style=\"\">Te gustaria aprender a utilizar la funcion logica SI?<\/p>\n<p style=\"\">Por ejemplo, puedes aumentar el salario al 10% para todos los trabajadores que leen aplica Excel contable y el 5% para los que no leen aplica Excel contable.<\/p>\n<p style=\"\">Lo primero es lo primero, debes de conocer primero la sintaxis:<\/p>\n<blockquote style=\"\"><p><strong>= SI (prueba_Logica; [valor_si_verdadero]; [valor_si_falso])<\/strong><\/p><\/blockquote>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el ejemplo explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-si.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292042\">Cuarta funcion: Como utilizar la funcion SI.CONJUNTO<\/h3>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"554\" height=\"96\" data-init-height=\"86\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Funcion-si-conjunto.png.webp\" data-width=\"620\" data-height=\"96\" style=\"aspect-ratio: auto 554 \/ 86;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<p style=\"\">La funcion SI.CONJUNTO es la cuarta funcion en la lista de formulas de excel para contadores:<\/p>\n<p style=\"\">Para iniciar a utilizar esta maravillosa funcion es muy necesario conocer la sintaxis, por lo tanto, a continacion vamos a conocer la sintaxis de la funcion:<\/p>\n<blockquote style=\"\"><p>= SI.CONJUNTO(prueba_logica1;valor_si_verdadero1;&#8230;)<\/p><\/blockquote>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el ejemplo explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/funcion-si-conjunto.html\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292043\">Quinta funcion: Como utilizar la funcion SUMAPRODUCTO<\/h3>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"301\" height=\"208\" data-init-height=\"101\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Ejemplo-de-la-Formula-Excel-SUMAPRODUCTO.png.webp\" data-width=\"620\" data-height=\"208\" style=\"aspect-ratio: auto 301 \/ 101;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<p style=\"\">La funcion SUMAPRODUCTO es la quinta funcion en la lista de formulas de excel para contadores:<\/p>\n<p style=\"\">Tomando en cuenta el primer paso para dominiar una funcion, lo primero es conocer la sintaxis de la funcion:<\/p>\n<blockquote style=\"\"><p>=SUMAPRODUCTO (MATRIZ1; MATRIZ2; MATRIZ3;\u2026\u2026)<\/p><\/blockquote>\n<p style=\"\"><strong>Por ejemplo:<\/strong> Si tienes datos en una columna como (3,5,6) y en otra columna (4,8,12) y se aplica la Formula SUMAPRODUCTO, obtendr\u00e1s un resultado de 124, porque (3*4+5*8+6*12 es igual a 124).<\/p>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-sumaproducto.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292044\">Sexta funcion: Como utilizar la funcion COINCIDIRX<\/h3>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"510\" height=\"197\" data-init-height=\"162\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/03\/Funcion-CoincidirX.png.webp\" data-width=\"620\" data-height=\"197\" style=\"aspect-ratio: auto 510 \/ 162;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<p style=\"\">La funcion COINCIDIRX es la sexta funcion en la lista de formulas de excel para contadores:<\/p>\n<p style=\"\">Siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis correspondiente a la funcion coincidirx:<\/p>\n<blockquote style=\"\"><p><strong>=COINCIDIRX(valor_buscado;matriz_buscada;[modo_de_coincidencia];[modo_de_busqueda])<\/strong><\/p><\/blockquote>\n<p>A continuacion los detalles de cada sintaxis:<\/p>\n<ul>\n<li><em><strong>Valor buscado<\/strong><\/em>&nbsp;= Aqui debes de reflejar la celda en la cual tienes el valor o texto a buscar.<\/li>\n<li><strong>Matriz buscada<\/strong>&nbsp;= Aqui vamos a el rango en el cual vamos a buscar el valor o texto.<\/li>\n<li><strong>Modo de Coincidencia<\/strong> = Aqui vamos a escribir como queremos buscar el valor dentro del la matriz bucada, si lo quieres buscar por: Coincidencia exacta, coincidencia exacta o el siguiente elemento menor, coincidencia exacta o el siguiente elemento mayor, Coincidencia de caracteres comodin.<\/li>\n<li>Modo de Busqueda = Aqui debes de escribir el orden como deseas buscar el valor buscado dentro de la matriz, puedes buscar por: Busqueda del primero al ultimo, Busqueda del ultimo al primero, Busqueda binaria (orden ascendente), Busqueda binaria (orden descendente).<\/li>\n<\/ul>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/funcion-coincidirx.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292045\">Septima funcion: Como utilizar la funcion BUSCARV<\/h3>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"630\" height=\"185\" data-init-height=\"188\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/01\/Datos-de-la-Formula-Excel-BUSCARV1.png.webp\" data-width=\"620\" data-height=\"185\" style=\"aspect-ratio: auto 630 \/ 188;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<p style=\"\">Este es una de las funciones mas utilizadas para automatizar excel, por lo tanto, siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis de la funcion:<\/p>\n<blockquote style=\"\"><p>= BUSCARV (valor buscado; matriz_buscar_en; indicador columnas; [ordenado])<\/p><\/blockquote>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-buscarv.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292046\">Octava funcion: Como utilizar la funcion BUSCARX<\/h3>\n<p><span><img decoding=\"async\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"612\" height=\"117\" data-init-height=\"115\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2021\/12\/Funcion-BuscarX.png.webp\" data-width=\"620\" data-height=\"117\" style=\"aspect-ratio: auto 612 \/ 115;\" title=\"La funcion sumar.si para contadores\"><\/span><\/p>\n<p style=\"\">Como dije al inicio, siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis de la funcion:<\/p>\n<blockquote style=\"\"><p>=BUSCARX(Valor_buscado;matriz_buscado;matriz_devuelta;[si_no_se_encuentra];[modo_de_coincidencia];[modo_de_busqueda])<\/p><\/blockquote>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/funcion-buscarx.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h3 id=\"t-1721685292047\">Novena funcion: Como utilizar la funcion FILTRAR<\/h3>\n<p><span><img decoding=\"async\" alt=\"\" width=\"578\" data-init-width=\"578\" height=\"308\" data-init-height=\"308\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2023\/07\/GIF-funcion-filtrar.gif.webp\" data-width=\"578\" data-height=\"308\" style=\"aspect-ratio: auto 578 \/ 308;\" data-init- data-><\/span><\/p>\n<p style=\"\">La funcion FILTRAR es la novena funcion en la lista de formulas de excel para contadores:<\/p>\n<p style=\"\">Para aprender a utilizar una funcion que debes de hacer en primer lugar?<\/p>\n<p style=\"\">Asi es, debes de conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis de la funcion:<\/p>\n<blockquote style=\"\"><p><strong>=FILTRAR(array; include; [If_empty])<\/strong><\/p><\/blockquote>\n<p>A continacion los detalles de cada sintaxis:<\/p>\n<p><em><strong>Array<\/strong><\/em>&nbsp;= es el rango o matriz que se va a filtrar.<\/p>\n<p><em><strong>Include<\/strong><\/em>&nbsp;= Una matriz de valores booleanos donde true representa una fila o columna que va a conservar.<\/p>\n<p><em><strong>If_empty&nbsp;<\/strong><\/em>= Se devuelve si no se conserva ningun elemento.<\/p>\n<p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso &#8211; &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/la-funcion-filtrar.html#video\" target=\"_blank\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p>\n<h2 id=\"t-1721751030977\">Te gustaria recibir tu certificado de participacion en este curso de 9 formulas de excel para contadores ?<\/h2>\n<p style=\"\">Puedes solicitar tu certificado de participacion, accediendo al curso en la sala de alumnos, tan solo aplicas las evaluaciones y si apruebas, de forma inmediato podras descargar tu certicado de participacion.<\/p>\n<p style=\"\">Si requieres mas detalles de como acceder al curso, puedes contactarme en whatsapp &#8211; &gt;&gt; <a href=\"https:\/\/api.whatsapp.com\/send?phone=14235290766\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">Pulsando clic aqui<\/a> &lt;&lt;.<\/p>\n<p style=\"\">Que tal te parecio el curso de 9 formulas de excel para contadores? Te gusto?<\/p>\n<p style=\"\">Y si te gusto este curso gratuito, no olvides compartirlo con tus amigos de facebook, pulsando clic en el botoon compartir:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>9 Impresionantes formulas de excel para contadores En la actualidad todo contador trabaja con excel o bien con las hojas de calculo de google para crear los informes financieros. Es importante que tu como contador domines las 9 formulas de excel para contadores y las aplicaques en tus labores diarios. Hola soy Roger Perez y [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":59439,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 class=\"\" id=\"t-1721685292048\">9 Impresionantes formulas de excel para contadores<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dc418d8c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">En la actualidad todo contador trabaja con excel o bien con las hojas de calculo de google para crear los informes financieros.<\/p><p style=\"\">Es importante que tu como contador domines las 9 <em><strong>formulas de excel para contadores<\/strong><\/em> y las aplicaques en tus labores diarios.<\/p><p style=\"\">Hola soy Roger Perez y estoy feliz de compartirte estas 9 maravillas de formulas para ti como contador.<\/p><p style=\"\">Entonces veamos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve-toc tve-elem-scroll tve-toc-expandable tcb-local-vars-root\" data-columns=\"2\" data-ct=\"toc-60676\" data-transition=\"slide\" data-headers=\"h1,h2,h3\" data-numbering=\"bullet_advanced\" data-highlight=\"progressive\" data-ct-name=\"Table of Content 08\" data-heading-style=\"{&quot;0&quot;:&quot;tve-u-190dccbf18f&quot;,&quot;1&quot;:&quot;tve-u-190dccbf192&quot;,&quot;2&quot;:&quot;tve-u-190dccbf194&quot;}\" data-css=\"tve-u-190dccbf188\" style=\"\" data-distribute=\"true\" data-bullet-style=\"{&quot;0&quot;:&quot;tve-u-190dccbf190&quot;,&quot;1&quot;:&quot;tve-u-190dccbf193&quot;,&quot;2&quot;:&quot;tve-u-190dccbf195&quot;}\" data-number-style=\"{&quot;0&quot;:&quot;tve-u-173dc808bfe&quot;,&quot;1&quot;:&quot;tve-u-17399ecbfc9&quot;,&quot;2&quot;:&quot;tve-u-173dc81164c&quot;}\" data-state-default=\"expanded\" data-columns-m=\"1\" data-animation=\"\" data-columns-d=\"2\" data-state-default-m=\"collapsed\" data-element-name=\"Table of Contents\" data-form-settings=\"__TCB_FORM__{&quot;form_identifier&quot;:&quot;formulas-de-excel-para-contadores-form-5sjtav&quot;}__TCB_FORM__\" data-id=\"m8alf2v2\"><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"6ba77\":{\"name\":\"Main Accent\",\"parent\":-1},\"19a93\":{\"name\":\"Main Accent Light\",\"parent\":\"6ba77\"}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"6ba77\":{\"val\":\"var(--tcb-skin-color-0)\"},\"19a93\":{\"val\":\"rgb(59, 203, 247)\",\"hsl_parent_dependency\":{\"h\":194,\"l\":0.6,\"s\":0.92}}},\"gradients\":[]},\"original\":{\"colors\":{\"6ba77\":{\"val\":\"rgb(70, 105, 233)\",\"hsl\":{\"h\":227,\"s\":0.78,\"l\":0.59,\"a\":1}},\"19a93\":{\"val\":\"rgb(84, 161, 248)\",\"hsl_parent_dependency\":{\"h\":211,\"s\":0.92,\"l\":0.65,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div><svg class=\"toc-icons\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><symbol id=\"toc-bullet-0-m8alf2v2\" viewBox=\"0 0 320 512\" data-id=\"icon-chevron-right-solid\"><path d=\"M285.476 272.971L91.132 467.314c-9.373 9.373-24.569 9.373-33.941 0l-22.667-22.667c-9.357-9.357-9.375-24.522-.04-33.901L188.505 256 34.484 101.255c-9.335-9.379-9.317-24.544.04-33.901l22.667-22.667c9.373-9.373 24.569-9.373 33.941 0L285.475 239.03c9.373 9.372 9.373 24.568.001 33.941z\"><\/path><\/symbol><symbol id=\"toc-bullet-1-m8alf2v2\" viewBox=\"0 0 320 512\" data-id=\"icon-chevron-right-solid\"><path d=\"M285.476 272.971L91.132 467.314c-9.373 9.373-24.569 9.373-33.941 0l-22.667-22.667c-9.357-9.357-9.375-24.522-.04-33.901L188.505 256 34.484 101.255c-9.335-9.379-9.317-24.544.04-33.901l22.667-22.667c9.373-9.373 24.569-9.373 33.941 0L285.475 239.03c9.373 9.372 9.373 24.568.001 33.941z\"><\/path><\/symbol><symbol id=\"toc-bullet-2-m8alf2v2\" viewBox=\"0 0 320 512\" data-id=\"icon-chevron-right-solid\"><path d=\"M285.476 272.971L91.132 467.314c-9.373 9.373-24.569 9.373-33.941 0l-22.667-22.667c-9.357-9.357-9.375-24.522-.04-33.901L188.505 256 34.484 101.255c-9.335-9.379-9.317-24.544.04-33.901l22.667-22.667c9.373-9.373 24.569-9.373 33.941 0L285.475 239.03c9.373 9.372 9.373 24.568.001 33.941z\"><\/path><\/symbol><\/svg><div class=\"tve-toc-divider\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\"><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(217, 217, 217, 0)\" data-css=\"tve-u-190dccbf189\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><\/div>\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-190dccbf18a\"><\/div>\n\t<div class=\"thrv_wrapper tve-toc-title show-icon reverse tcb-icon-display tve-no-dropzone tve-prevent-content-edit\" data-css=\"tve-u-190dccbf18b\" style=\"\" data-tcb_hover_state_parent=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\">\n\t\t<div class=\"tve-toc-title-icon\" data-icon-code=\"icon-arrow-alt-circle-up-outlined\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-alt-circle-up-outlined\" data-name=\"\"><path d=\"M256 504c137 0 248-111 248-248S393 8 256 8 8 119 8 256s111 248 248 248zm0-448c110.5 0 200 89.5 200 200s-89.5 200-200 200S56 366.5 56 256 145.5 56 256 56zm20 328h-40c-6.6 0-12-5.4-12-12V256h-67c-10.7 0-16-12.9-8.5-20.5l99-99c4.7-4.7 12.3-4.7 17 0l99 99c7.6 7.6 2.2 20.5-8.5 20.5h-67v116c0 6.6-5.4 12-12 12z\"><\/path><\/svg><\/div>\n\t\t<div class=\"thrv_wrapper thrv_text_element tve_no_icons\">\t\t\t<div class=\"tcb-plain-text\" style=\"\" data-css=\"tve-u-190dccbf18c\">Tabla de Contenido:<\/div>&nbsp;\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"tve-cb tve-toc-content tve-prevent-content-edit\" style=\"display: inline-block;\">\n\t\t\n\n\t\t<div class=\"thrv_wrapper tve-toc-list tcb-no-delete tcb-no-save tcb-no-clone tve-no-dropzone\" data-css=\"tve-u-190dccbf18d\" style=\"\">\n\t\t\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-190dccbf18e\"><\/div>\n\t\t\t<div class=\"tve-cb\">\n\t\t\t\t<div class=\"tve_ct_content tve_clearfix\"><div class=\"ct_column\"><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H1\" data-css=\"tve-u-190dccbf18f\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292048\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m8alf2v2\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-190dccbf190\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292048\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">9 Impresionantes formulas de excel para contadores<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-190dccbf192\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292038\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m8alf2v2\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-190dccbf193\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292038\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Cuales son estas formulas de excel para contadores?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292039\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292039\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Primera funcion: Como utilizar la funcion SUMAR.SI<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292040\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292040\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Segunda funcion: Como utilizar la funcion SUMAR.SI.CONJUNTO<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292041\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292041\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Tercera funcion: Como utilizar la funcion logica SI<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292042\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292042\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Cuarta funcion: Como utilizar la funcion SI.CONJUNTO<\/a><\/div><\/div><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(217, 217, 217, 0)\" data-css=\"tve-u-190dccbf189\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><div class=\"ct_column\"><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292043\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292043\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Quinta funcion: Como utilizar la funcion SUMAPRODUCTO<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292044\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292044\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sexta funcion: Como utilizar la funcion COINCIDIRX<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292045\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292045\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Septima funcion: Como utilizar la funcion BUSCARV<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292046\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292046\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Octava funcion: Como utilizar la funcion BUSCARX<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-190dccbf194\" data-element-name=\"Heading Level 3\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet2 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721685292047\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-2-m8alf2v2\" data-element-name=\"Icon Level 3\" data-css=\"tve-u-190dccbf195\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-2-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721685292047\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Novena funcion: Como utilizar la funcion FILTRAR<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-190dccbf192\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1721751030977\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m8alf2v2\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-190dccbf193\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m8alf2v2\"><\/use><\/svg><\/div><a href=\"#t-1721751030977\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Te gustaria recibir tu certificado de participacion en este curso de 9 formulas de excel para contadores ?<\/a><\/div><\/div><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(217, 217, 217, 0)\" data-css=\"tve-u-190dccbf189\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" id=\"t-1721685292038\">Cuales son estas formulas de excel para contadores?<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dc5ce299\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">A continuacion voy a compartirte la lista de <em><strong>formulas de excel para contadores<\/strong><\/em>, en total en este curso basico, te compartire 9 funciones especificas:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-function-variant-solid\" data-css=\"tve-u-190dc5cc5f4\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc712fab\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">La Funcion \"SUMAR.SI\" - &gt;&gt; <a href=\"#1\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc712fad\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">La funcion \"SUMAR.SI.CONJUNTO\" - &gt;&gt; <a href=\"#2\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc712fae\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">Funcion logica \"SI\" - &gt;&gt; <a href=\"#3\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc6232b7\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">La funcion \"SI.CONJUNTO\" - &gt;&gt; <a href=\"#4\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc628831\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">La funcion \"SUMAPRODUCTO\" - &gt;&gt; <a href=\"#5\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc62eec4\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">Funcion \"COINCIDIRX\" - &gt;&gt; <a href=\"#6\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc690f38\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">Funcion \"BUSCARV\" - &gt;&gt; <a href=\"#7\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style \" data-css=\"tve-u-190dcb186d1\"><svg class=\"tcb-icon\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\"><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">La funcion \"BUSCARX\" - &gt;&gt; <a href=\"#8\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle<\/a> &lt;&lt;.<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-190dc69c800\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root tcb-icon-display\" data-css=\"tve-u-190dc7117ba\" style=\"border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important;\" data-style-d=\"circle_inverted\" data-icon-default-gradient=\"linear-gradient(180deg, #ffffff 0%, #000000 100%)\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 24 24\" data-id=\"icon-function-variant-solid\" data-name=\"\" style=\"--tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab);\"><defs><linearGradient id=\"tcb-gradient-default-tve-u-190dc712fab\" x1=\"0.00\" y1=\"1.00\" x2=\"-0.00\" y2=\"-1.00\"><stop offset=\"0%\" stop-color=\"#ffffff\"><\/stop><stop offset=\"50%\" stop-color=\"#000000\"><\/stop><\/linearGradient><\/defs><path d=\"M12.42,5.29C11.32,5.19 10.35,6 10.25,7.11L10,10H12.82V12H9.82L9.38,17.07C9.18,19.27 7.24,20.9 5.04,20.7C3.79,20.59 2.66,19.9 2,18.83L3.5,17.33C3.83,18.38 4.96,18.97 6,18.63C6.78,18.39 7.33,17.7 7.4,16.89L7.82,12H4.82V10H8L8.27,6.93C8.46,4.73 10.39,3.1 12.6,3.28C13.86,3.39 15,4.09 15.66,5.17L14.16,6.67C13.91,5.9 13.23,5.36 12.42,5.29M22,13.65L20.59,12.24L17.76,15.07L14.93,12.24L13.5,13.65L16.35,16.5L13.5,19.31L14.93,20.72L17.76,17.89L20.59,20.72L22,19.31L19.17,16.5L22,13.65Z\" fill=\"\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-190dc5cab9b\">La Funcion \"FILTRAR\" - &nbsp;&gt;&gt; <a href=\"#9\" class=\"tve-jump-scroll\" style=\"outline: none;\">Clic aqui para mas detalle <\/a>&lt;&lt;.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dc5ce299\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Ahora que ya conoces la lista de las funciones que debes de manejar en las formulas de excel para contadores, voy a compartirte los detalles de como utilizar estas funciones:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"1\"><h3 id=\"t-1721685292039\" class=\"\">Primera funcion: Como utilizar la funcion SUMAR.SI<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">La funcion SUMAR.SI es la primera funcion en la lista de formulas de excel para contadores:<\/p><p style=\"\">Para iniciar, siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a ver la sintaxis:<\/p><blockquote class=\"\" style=\"\">=SUMAR.SI(El Rango del criterio; Criterio; el Rango que quieres Sumar )<\/blockquote><p style=\"\">En forma de ejemplo solo para comprender la sintaxis:<\/p><blockquote class=\"\" style=\"\">= SUMAR.SI( Rango de Productos; \"Cementos\"; Ventas)<\/blockquote><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-sumar-si.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"620\" height=\"162\" data-init-height=\"162\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/11\/Formula-Excel-SUMAR-SI-SUMAR.SI_.png.webp\" data-width=\"620\" data-height=\"162\" style=\"aspect-ratio: auto 620 \/ 162;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"2\"><h3 id=\"t-1721685292040\" class=\"\">Segunda funcion: Como utilizar la funcion SUMAR.SI.CONJUNTO<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p>La funcion SUMAR.SI.CONJUNTO es la segunda funcion en la lista de formulas de excel para contadores:<\/p><p>Alguna vez has o\u00eddo hablar a miles de directivos de todo el mundo decir...\"\u00bfCu\u00e1ntas ventas x &nbsp;hicimos en la regi\u00f3n A, del producto B, tipo de cliente C en el mes M?\" &nbsp;Como responder\u00edas en ese mismo momento si la pregunta es para ti?<\/p><p>Como responder\u00edas a la Pregunta sin usar excesivas filtraciones y selecciones de celdas en Excel?<\/p><p style=\"\">Para responder a estas pregunta lo primero es lo primero, debes de conocer primero la sintaxis:<\/p><blockquote class=\"\">= SUMAR.SI.CONJUNTO (lo que quieres sumar, columna condici\u00f3n 1, condici\u00f3n, condiciones columna 2, Estado ....)<\/blockquote><p>Ejemplo:<\/p><blockquote class=\"\">= SUMAR.SI.CONJUNTO (ventas, regiones, \"A\", los productos, \"B\", tipos de clientes, \"C\", el mes, \"M\")<\/blockquote><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el ejemplo explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-las-formulas-excel-sumar-si-conjunto.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"3\"><h3 id=\"t-1721685292041\" class=\"\">Tercera funcion: Como utilizar la funcion logica SI<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"532\" height=\"411\" data-init-height=\"353\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/01\/Aumento-de-Salario-Formula-Excel-SI-1.png.webp\" data-width=\"620\" data-height=\"411\" style=\"aspect-ratio: auto 532 \/ 353;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">La funcion logica SI es la tercer funcion en la lista de formulas de excel para contadores:<\/p><p style=\"\">Te gustaria aprender a utilizar la funcion logica SI?<\/p><p style=\"\">Por ejemplo, puedes aumentar el salario al 10% para todos los trabajadores que leen aplica Excel contable y el 5% para los que no leen aplica Excel contable.<\/p><p style=\"\">Lo primero es lo primero, debes de conocer primero la sintaxis:<\/p><blockquote class=\"\" style=\"\"><strong>= SI (prueba_Logica; [valor_si_verdadero]; [valor_si_falso])<\/strong><\/blockquote><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el ejemplo explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-si.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"4\"><h3 id=\"t-1721685292042\" class=\"\">Cuarta funcion: Como utilizar la funcion SI.CONJUNTO<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"554\" height=\"96\" data-init-height=\"86\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2020\/04\/Funcion-si-conjunto.png.webp\" data-width=\"620\" data-height=\"96\" style=\"aspect-ratio: auto 554 \/ 86;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">La funcion SI.CONJUNTO es la cuarta funcion en la lista de formulas de excel para contadores:<\/p><p style=\"\">Para iniciar a utilizar esta maravillosa funcion es muy necesario conocer la sintaxis, por lo tanto, a continacion vamos a conocer la sintaxis de la funcion:<\/p><blockquote class=\"\" style=\"\">= SI.CONJUNTO(prueba_logica1;valor_si_verdadero1;...)<\/blockquote><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el ejemplo explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/funcion-si-conjunto.html\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"5\"><h3 id=\"t-1721685292043\" class=\"\">Quinta funcion: Como utilizar la funcion SUMAPRODUCTO<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"301\" height=\"208\" data-init-height=\"101\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/02\/Ejemplo-de-la-Formula-Excel-SUMAPRODUCTO.png.webp\" data-width=\"620\" data-height=\"208\" style=\"aspect-ratio: auto 301 \/ 101;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">La funcion SUMAPRODUCTO es la quinta funcion en la lista de formulas de excel para contadores:<\/p><p style=\"\">Tomando en cuenta el primer paso para dominiar una funcion, lo primero es conocer la sintaxis de la funcion:<\/p><blockquote class=\"\" style=\"\">=SUMAPRODUCTO (MATRIZ1; MATRIZ2; MATRIZ3;\u2026\u2026)<\/blockquote><p style=\"\"><strong>Por ejemplo:<\/strong> Si tienes datos en una columna como (3,5,6) y en otra columna (4,8,12) y se aplica la Formula SUMAPRODUCTO, obtendr\u00e1s un resultado de 124, porque (3*4+5*8+6*12 es igual a 124).<\/p><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-sumaproducto.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"6\"><h3 id=\"t-1721685292044\" class=\"\">Sexta funcion: Como utilizar la funcion COINCIDIRX<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"510\" height=\"197\" data-init-height=\"162\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/03\/Funcion-CoincidirX.png.webp\" data-width=\"620\" data-height=\"197\" style=\"aspect-ratio: auto 510 \/ 162;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">La funcion COINCIDIRX es la sexta funcion en la lista de formulas de excel para contadores:<\/p><p style=\"\">Siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis correspondiente a la funcion coincidirx:<\/p><blockquote class=\"\" style=\"\"><strong>=COINCIDIRX(valor_buscado;matriz_buscada;[modo_de_coincidencia];[modo_de_busqueda])<\/strong><\/blockquote><p>A continuacion los detalles de cada sintaxis:<\/p><ul class=\"\"><li><em><strong>Valor buscado<\/strong><\/em>&nbsp;= Aqui debes de reflejar la celda en la cual tienes el valor o texto a buscar.<\/li><li><strong>Matriz buscada<\/strong>&nbsp;= Aqui vamos a el rango en el cual vamos a buscar el valor o texto.<\/li><li><strong>Modo de Coincidencia<\/strong> = Aqui vamos a escribir como queremos buscar el valor dentro del la matriz bucada, si lo quieres buscar por: Coincidencia exacta, coincidencia exacta o el siguiente elemento menor, coincidencia exacta o el siguiente elemento mayor, Coincidencia de caracteres comodin.<\/li><li>Modo de Busqueda = Aqui debes de escribir el orden como deseas buscar el valor buscado dentro de la matriz, puedes buscar por: Busqueda del primero al ultimo, Busqueda del ultimo al primero, Busqueda binaria (orden ascendente), Busqueda binaria (orden descendente).<\/li><\/ul><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/funcion-coincidirx.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"7\"><h3 id=\"t-1721685292045\" class=\"\">Septima funcion: Como utilizar la funcion BUSCARV<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"630\" height=\"185\" data-init-height=\"188\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2015\/01\/Datos-de-la-Formula-Excel-BUSCARV1.png.webp\" data-width=\"620\" data-height=\"185\" style=\"aspect-ratio: auto 630 \/ 188;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Este es una de las funciones mas utilizadas para automatizar excel, por lo tanto, siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis de la funcion:<\/p><blockquote class=\"\" style=\"\">= BUSCARV (valor buscado; matriz_buscar_en; indicador columnas; [ordenado])<\/blockquote><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/como-aplicar-la-formula-excel-buscarv.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"8\"><h3 id=\"t-1721685292046\" class=\"\">Octava funcion: Como utilizar la funcion BUSCARX<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dcdfd175\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image tcb-moved-image\" alt=\"Formulas de excel para contadores\" width=\"620\" data-init-width=\"612\" height=\"117\" data-init-height=\"115\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2021\/12\/Funcion-BuscarX.png.webp\" data-width=\"620\" data-height=\"117\" style=\"aspect-ratio: auto 612 \/ 115;\" data-css=\"tve-u-190dcdfdcaf\" title=\"La funcion sumar.si para contadores\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Como dije al inicio, siempre lo primero que debes hacer es conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis de la funcion:<\/p><blockquote class=\"\" style=\"\">=BUSCARX(Valor_buscado;matriz_buscado;matriz_devuelta;[si_no_se_encuentra];[modo_de_coincidencia];[modo_de_busqueda])<\/blockquote><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/funcion-buscarx.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\" id=\"9\"><h3 id=\"t-1721685292047\" class=\"\">Novena funcion: Como utilizar la funcion FILTRAR<\/h3><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-190dd9202f6\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image\" alt=\"\" width=\"578\" data-init-width=\"578\" height=\"308\" data-init-height=\"308\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2023\/07\/GIF-funcion-filtrar.gif.webp\" data-width=\"578\" data-height=\"308\" style=\"aspect-ratio: auto 578 \/ 308;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190dcd8ee0d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190dc418d87\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">La funcion FILTRAR es la novena funcion en la lista de formulas de excel para contadores:<\/p><p style=\"\">Para aprender a utilizar una funcion que debes de hacer en primer lugar?<\/p><p style=\"\">Asi es, debes de conocer la sintaxis de la funcion, a continacion vamos a conocer la sintaxis de la funcion:<\/p><blockquote class=\"\" style=\"\"><strong>=FILTRAR(array; include; [If_empty])<\/strong><\/blockquote><p>A continacion los detalles de cada sintaxis:<\/p><p><em><strong>Array<\/strong><\/em>&nbsp;= es el rango o matriz que se va a filtrar.<\/p><p><em><strong>Include<\/strong><\/em>&nbsp;= Una matriz de valores booleanos donde true representa una fila o columna que va a conservar.<\/p><p><em><strong>If_empty&nbsp;<\/strong><\/em>= Se devuelve si no se conserva ningun elemento.<\/p><p style=\"\">Ahora que ya conoces la sintaxis, puedes ver el video explicativo de como aplicar la funcion paso a paso - &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/la-funcion-filtrar.html#video\" target=\"_blank\" class=\"\" style=\"outline: none;\">Clic aqui para ver<\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" id=\"t-1721751030977\">Te gustaria recibir tu certificado de participacion en este curso de 9 formulas de excel para contadores ?<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-190e177f7c8\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-190e177f7c0\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Puedes solicitar tu certificado de participacion, accediendo al curso en la sala de alumnos, tan solo aplicas las evaluaciones y si apruebas, de forma inmediato podras descargar tu certicado de participacion.<\/p><p style=\"\">Si requieres mas detalles de como acceder al curso, puedes contactarme en whatsapp - &gt;&gt; <a href=\"https:\/\/api.whatsapp.com\/send?phone=14235290766\" target=\"_blank\" class=\"\" style=\"outline: none;\">Pulsando clic aqui<\/a> &lt;&lt;.<\/p><p style=\"\">Que tal te parecio el curso de 9 formulas de excel para contadores? Te gusto?<\/p><p style=\"\">Y si te gusto este curso gratuito, no olvides compartirlo con tus amigos de facebook, pulsando clic en el botoon compartir:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-190e17c40d0\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-190e17c40cf\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-1959b412d54\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1959b412d53\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-1959b412d55\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-1959b412d56\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-1959b412d57\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-1959b412d58\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-1959b412d59\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-190dc418d87\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-190dc418d87\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-190dc418d87\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-190dc418d8c\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-190dc5cc5f4\"] { margin-top: 0px !important; padding-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-190dc5ce299\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-190dc6232b7\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc628831\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc62eec4\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc690f38\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc7117ba\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc712fab\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dc712fab); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc712fad\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }[data-css=\"tve-u-190dc712fae\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }:not(#tve) [data-css=\"tve-u-190dc712fab\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc712fad\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc712fae\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc6232b7\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc628831\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc62eec4\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc690f38\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }:not(#tve) [data-css=\"tve-u-190dc7117ba\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }[data-css=\"tve-u-190dcb186d1\"] { --tcb-local-color-icon: rgb(11,32,244); --tcb-local-color-var: rgb(11,32,244); --tve-icon-size: 18px; border: none; border-radius: calc(var(--tve-icon-size) * 2); background-size: auto; background-attachment: scroll, scroll, scroll; background-position: 50% 50%; background-repeat: no-repeat; --tve-applied-border: none; --tcb-gradient-default-value: url(#tcb-gradient-default-tve-u-190dcb186d1); padding: calc(var(--tve-icon-size) \/ 3) !important; background-image: linear-gradient(var(--tcb-local-color-icon),var(--tcb-local-color-icon)) !important; --tve-applied-background-image: linear-gradient(var$(--tcb-local-color-icon),var$(--tcb-local-color-icon)) !important; }:not(#tve) [data-css=\"tve-u-190dcb186d1\"] > :first-child { color: rgb(255, 255, 255); --tve-applied-color: #fff; }[data-css=\"tve-u-190dccbf18a\"] { background-image: linear-gradient(168deg,var(--tcb-local-color-6ba77) 0%,rgba(23,35,78,0) 100%,#000000 100%) !important; background-color: var(--tcb-local-color-19a93) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-190dccbf188\"] { --tve-toc-indent: 25px; float: none; padding: 30px !important; margin-left: auto !important; margin-right: auto !important; --tcb-local-color-6ba77: var(--tcb-skin-color-0) !important; --tcb-local-color-19a93: rgb(59,203,247) !important; margin-top: 0px !important; }[data-css=\"tve-u-190dccbf18e\"] { overflow: hidden; box-shadow: none; border: none !important; border-radius: 10px !important; }[data-css=\"tve-u-190dccbf18d\"] { padding: 0px !important; margin-bottom: 0px !important; margin-top: 20px !important; }:not(#tve) [data-css=\"tve-u-190dccbf18e\"] { background-image: none !important; }[data-css=\"tve-u-190dccbf18f\"] { --tve-font-size: 17px; font-size: var(--tve-font-size,17px); color: var(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; padding: 5px 10px !important; margin-bottom: 10px !important; background-image: linear-gradient(rgba(0, 0, 0, 0.1), rgba(0, 0, 0, 0.1)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; margin-top: 10px !important; }:not(#tve) [data-css=\"tve-u-190dccbf18f\"]:hover { font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; text-decoration: var(--tve-text-decoration,none) !important; --tve-text-decoration: none !important; background-image: linear-gradient(rgba(0, 0, 0, 0.2), rgba(0, 0, 0, 0.2)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; --tve-applied-background-image: linear-gradient(rgba(0,0,0,0.2),rgba(0,0,0,0.2)) !important; }[data-css=\"tve-u-190dccbf192\"] { --tve-font-size: 17px; font-size: var(--tve-font-size,17px); color: var(--tve-color,rgba(255,255,255,0.8)); --tve-color: rgba(255,255,255,0.8); --tcb-applied-color: rgba(255,255,255,0.8); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; font-style: var(--tve-font-style,normal); --tve-font-style: normal; line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; padding: 3px 10px 3px 0px !important; }:not(#tve) [data-css=\"tve-u-190dccbf192\"]:hover { font-style: var(--tve-font-style,normal) !important; --tve-font-style: normal !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; --tve-applied-color: var$(--tve-color,rgb(255,255,255)) !important; --tve-applied---tve-color: rgb(255,255,255) !important; }[data-css=\"tve-u-190dccbf194\"] { --tve-font-size: 17px; font-size: var(--tve-font-size,17px); color: var(--tve-color,rgba(255,255,255,0.8)); --tve-color: rgba(255,255,255,0.8); --tcb-applied-color: rgba(255,255,255,0.8); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; font-style: var(--tve-font-style,normal); --tve-font-style: normal; line-height: var(--tve-line-height,1.5em); --tve-line-height: 1.5em; padding: 3px 10px 3px 0px !important; }:not(#tve) [data-css=\"tve-u-190dccbf194\"]:hover { font-style: var(--tve-font-style,normal) !important; --tve-font-style: normal !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; }[data-css=\"tve-u-190dccbf18b\"] { --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); margin-top: 0px !important; margin-bottom: 0px !important; padding: 0px !important; }[data-css=\"tve-u-190dccbf18b\"].tve-state-expanded { --animation-angle: 180deg; }[data-css=\"tve-u-190dccbf18c\"] { line-height: 1.5em !important; }[data-css=\"tve-u-190dccbf189\"] .tve_sep { background-image: linear-gradient(rgba(217, 217, 217, 0), rgba(217, 217, 217, 0)) !important; width: 1px !important; --tve-applied-background-image: linear-gradient(rgba(217,217,217,0),rgba(217,217,217,0)) !important; }:not(#tve) [data-css=\"tve-u-190dccbf18b\"] p, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] li, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] blockquote, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] address, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] label, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] h1, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] h2, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] h3, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] h4, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] h5, :not(#tve) [data-css=\"tve-u-190dccbf18b\"] h6 { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tcb-applied-color: rgb(255,255,255); }[data-css=\"tve-u-190dccbf18b\"] .tve-toc-title-icon { font-size: 22px !important; width: 22px !important; height: 22px !important; color: rgba(255, 255, 255, 0.8) !important; --tve-applied-color: rgba(255,255,255,0.8) !important; }[data-css=\"tve-u-190dccbf18b\"].tve-state-expanded .tve-toc-title-icon { color: rgb(255, 255, 255) !important; --tve-applied-color: rgb(255,255,255) !important; }:not(#tve) [data-css=\"tve-u-190dccbf18b\"]:hover:not(.tve-state-expanded) .tve-toc-title-icon { color: rgb(255, 255, 255) !important; --tve-applied-color: rgb(255,255,255) !important; }[data-css=\"tve-u-190dccbf190\"] { font-size: 11px; width: 11px; height: 11px; --tve-icon-size: 11px; padding: 0px !important; }[data-css=\"tve-u-190dccbf193\"] { font-size: 11px; width: 11px; height: 11px; --tve-icon-size: 11px; padding: 0px !important; }[data-css=\"tve-u-190dccbf195\"] { font-size: 11px; width: 11px; height: 11px; --tve-icon-size: 11px; padding: 0px !important; }[data-css=\"tve-u-173dc808bfe\"] { padding: 0px !important; }[data-css=\"tve-u-17399ecbfc9\"] { padding: 0px !important; }[data-css=\"tve-u-173dc81164c\"] { padding: 0px !important; }[data-css=\"tve-u-190dccbf18f\"].tve-state-expanded { background-image: linear-gradient(rgba(0, 0, 0, 0.2), rgba(0, 0, 0, 0.2)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; --tve-applied-background-image: linear-gradient(rgba(0,0,0,0.2),rgba(0,0,0,0.2)) !important; }:not(#tve) [data-css=\"tve-u-190dccbf18c\"] { font-size: 22px !important; }[data-css=\"tve-u-190dccbf192\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); background-color: rgba(255, 255, 255, 0.05) !important; --tve-applied-background-color: rgba(255,255,255,0.05) !important; }[data-css=\"tve-u-190dccbf194\"].tve-state-expanded { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); --tcb-applied-color: rgb(255,255,255); background-color: rgba(255, 255, 255, 0.05) !important; --tve-applied-background-color: rgba(255,255,255,0.05) !important; }[data-css=\"tve-u-190dcd8ee0d\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-top: 10px !important; }[data-css=\"tve-u-190dcdfd175\"] { width: 620px; --tve-alignment: center; float: none; margin: 10px auto !important; }[data-css=\"tve-u-190dd9202f6\"] { width: 578px; --tve-alignment: center; float: none; margin: 0px auto 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-190e177f7c0\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-190e177f7c0\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-190e177f7c0\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-190e177f7c8\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-190e17c40cf\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-190e17c40d0\"]::after { clear: both; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1959b412d53\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1959b412d53\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-1959b412d53\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-1959b412d54\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-1959b412d55\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-1959b412d56\"] { --tcb-text-highlight-color: rgb(237, 243, 13) !important; }[data-css=\"tve-u-1959b412d57\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-1959b412d58\"] { --tcb-text-highlight-color: rgb(30, 184, 76) !important; }[data-css=\"tve-u-1959b412d59\"] { --tcb-text-highlight-color: transparent !important; }}@media (max-width: 767px){[data-css=\"tve-u-190dccbf188\"] { --tve-toc-indent: 8px; padding: 15px !important; }[data-css=\"tve-u-190dccbf18f\"] { line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; }[data-css=\"tve-u-190dccbf192\"] { line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; padding-top: 5px !important; padding-bottom: 5px !important; }[data-css=\"tve-u-190dccbf194\"] { line-height: var(--tve-line-height,14px); --tve-line-height: 14px; padding-top: 5px !important; padding-bottom: 5px !important; }[data-css=\"tve-u-190dccbf18b\"].tve-state-expanded .tve-toc-title-icon { font-size: 20px !important; width: 20px !important; height: 20px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[7633,7631,7632],"class_list":["post-58927","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-excel-para-contadores","tag-formulas-de-excel-para-contadores","tag-formulas-para-contadores","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/58927","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=58927"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/58927\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/59439"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=58927"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=58927"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=58927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}