{"version":"1.0","provider_name":"Excel Advisor","provider_url":"https:\/\/exceladvisor.org\/es","author_name":"Equipo editorial","author_url":"https:\/\/exceladvisor.org\/es\/author\/sq4n1shex3els\/","title":"\u00bfc\u00f3mo utilizar subtotal con si en excel?","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"0cZo4YNVZH\"><a href=\"https:\/\/exceladvisor.org\/es\/subtotal-si-2\/\">\u00bfc\u00f3mo utilizar subtotal con si en excel?<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/exceladvisor.org\/es\/subtotal-si-2\/embed\/#?secret=0cZo4YNVZH\" width=\"600\" height=\"338\" title=\"\u00ab\u00bfc\u00f3mo utilizar subtotal con si en excel?\u00bb \u2014 Excel Advisor\" data-secret=\"0cZo4YNVZH\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/exceladvisor.org\/es\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"ESTA F\u00d3RMULA ES PURA MAGIA. Si desea escribir una f\u00f3rmula SUBTOTAL en Excel con IF (condici\u00f3n), necesita usar varias funciones para hacerlo. Pero antes de hacer eso, comprendamos los datos que tenemos para este ejemplo. En el ejemplo anterior, tiene tres columnas: Nombre losa de edad G\u00e9nero Y cuando filtra una losa de la columna [&hellip;]","thumbnail_url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-sous-total-avec-if.png"}