{"id":194,"date":"2023-11-12T15:00:24","date_gmt":"2023-11-12T15:00:24","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/"},"modified":"2023-12-25T10:27:34","modified_gmt":"2023-12-25T10:27:34","slug":"suma-si-es-mayor-que-cero-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/","title":{"rendered":"\u00bfc\u00f3mo sumar valores mayores que cero?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2309796911\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>Para sumar valores mayores que cero, puede usar la funci\u00f3n SUMAR.SI para especificar una condici\u00f3n. En SUMAR.SI, el argumento de criterios le permite escribir una condici\u00f3n en la que puede usar el operador mayor que e ingresar un cero (0). Puede utilizar el mismo rango para probar las condiciones y calcular la suma. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79474\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma-valor-mayor-que-cero\" width=\"599\" height=\"409\"><\/figure>\n<\/div>\n<p> O tambi\u00e9n puedes usar dos rangos diferentes, uno para probar la condici\u00f3n y otro para obtener la suma.<\/p>\n<h2 class=\"wp-block-heading\"> Pasos para escribir una f\u00f3rmula: SUMAR SI mayor que cero<\/h2>\n<p> Puede utilizar los pasos a continuaci\u00f3n:<\/p>\n<ol type=\"1\">\n<li> Primero, en una celda, ingrese la funci\u00f3n SUMAR.SI.<\/li>\n<li> Despu\u00e9s de eso, en el rango de criterios, consulte la columna D\u00edas pasados.<\/li>\n<li> Luego, en el argumento de criterios, utilice \u00ab&gt;0\u00bb.<\/li>\n<li> Ahora en sum_range consulte la columna Cantidad.<\/li>\n<li> Al final, presione Enter para obtener el resultado. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79475\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-somme-si-superieur-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumif-mayor-que-cero\" width=\"694\" height=\"412\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(B2:B11,\"&gt;0\",C2:C11)<\/code><\/pre>\n<p> Como puedes ver, solo te devuelve la suma de los valores de la columna Cantidad, donde tienes un valor mayor que cero en la columna D\u00edas Pasados. Puedes ver el mismo resultado en la <a href=\"https:\/\/exceladvisor.org\/es\/barra-de-estado\/\">barra de estado<\/a> . <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79476\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-renvoie-la-valeur-somme.png\" sizes=\"auto, \" srcset=\"\" alt=\"valor-suma-retorno\" width=\"581\" height=\"396\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Usar una referencia de celda para especificar cero<\/h2>\n<p> Al escribir la f\u00f3rmula, puede hacer referencia a una celda para especificar cero en ella. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79477\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Reference-de-4-cellules-pour-specifier-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"referencia-de-celda-para-especificar-cero\" width=\"673\" height=\"374\"><\/figure>\n<\/div>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIF(B2:B11,\"&gt;\"&amp;D1,C2:C11)<\/code><\/pre>\n<p> En la f\u00f3rmula anterior, en los criterios, usamos un signo y luego nos referimos a la celda D1 donde tenemos el cero. Esto da como resultado una f\u00f3rmula din\u00e1mica en la que puede cambiar la condici\u00f3n de la celda en lugar de cambiarla desde la f\u00f3rmula.<\/p>\n<h2 class=\"wp-block-heading\"> \u00bfQu\u00e9 pasa si quiero usar SUMIFS en lugar de SUMIF?<\/h2>\n<p> S\u00ed, puedes usarlo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79478\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-sommes-superieures-a-zero.png\" sizes=\"auto, \" srcset=\"\" alt=\"sumifs-mayores-que-cero\" width=\"674\" height=\"381\"><\/figure>\n<\/div>\n<p> En SUMIFS primero debe especificar sum_range. Despu\u00e9s de eso, debe especificar el rango de criterios y, al final, debe ingresar los criterios para probar.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=SUMIFS(C2:C11,B2:B11,\"&gt;0\")<\/code><\/pre>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/somme-si-superieure-a-zero.xlsx\" rel=\"nofollow\">Descargar<\/a><\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que\/\">Suma mayor que valores usando SUMAR.SI<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumos-no-iguales\/\">Suma de valores no iguales (SUMIFS) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-sumifs-o-logica\/\">SUMAR.SI\/SUMAR.SI con l\u00f3gica OR en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/sumif-con-comodines\/\">SUMAR.SI con comodines en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-de-valores-entre-dos-fechas\/\">Rango de fechas SUMIFS (suma de valores entre dos matrices de fechas)<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para sumar valores mayores que cero, puede usar la funci\u00f3n SUMAR.SI para especificar una condici\u00f3n. En SUMAR.SI, el argumento de criterios le permite escribir una condici\u00f3n en la que puede usar el operador mayor que e ingresar un cero (0). Puede utilizar el mismo rango para probar las condiciones y calcular la suma. O tambi\u00e9n [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-194","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo sumar valores mayores que cero?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo sumar valores mayores que cero?\" \/>\n<meta property=\"og:description\" content=\"Para sumar valores mayores que cero, puede usar la funci\u00f3n SUMAR.SI para especificar una condici\u00f3n. En SUMAR.SI, el argumento de criterios le permite escribir una condici\u00f3n en la que puede usar el operador mayor que e ingresar un cero (0). Puede utilizar el mismo rango para probar las condiciones y calcular la suma. O tambi\u00e9n [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:27:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/\",\"name\":\"\u00bfc\u00f3mo sumar valores mayores que cero?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\",\"datePublished\":\"2023-11-12T15:00:24+00:00\",\"dateModified\":\"2023-12-25T10:27:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo sumar valores mayores que cero?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo sumar valores mayores que cero?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo sumar valores mayores que cero?","og_description":"Para sumar valores mayores que cero, puede usar la funci\u00f3n SUMAR.SI para especificar una condici\u00f3n. En SUMAR.SI, el argumento de criterios le permite escribir una condici\u00f3n en la que puede usar el operador mayor que e ingresar un cero (0). Puede utilizar el mismo rango para probar las condiciones y calcular la suma. O tambi\u00e9n [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:27:34+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/","url":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/","name":"\u00bfc\u00f3mo sumar valores mayores que cero?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png","datePublished":"2023-11-12T15:00:24+00:00","dateModified":"2023-12-25T10:27:34+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-superieure-a-zero.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-si-es-mayor-que-cero-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo sumar valores mayores que cero?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=194"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/194\/revisions"}],"predecessor-version":[{"id":1209,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/194\/revisions\/1209"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}