{"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 sumif con comodines?","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"iMnjW7kVpy\"><a href=\"https:\/\/exceladvisor.org\/es\/sumif-con-comodines\/\">\u00bfc\u00f3mo utilizar sumif con comodines?<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/exceladvisor.org\/es\/sumif-con-comodines\/embed\/#?secret=iMnjW7kVpy\" width=\"600\" height=\"338\" title=\"\u00ab\u00bfc\u00f3mo utilizar sumif con comodines?\u00bb \u2014 Excel Advisor\" data-secret=\"iMnjW7kVpy\" 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":"SUMAR.SI es una de mis funciones favoritas de Excel y estoy seguro de que tambi\u00e9n es la tuya. Pero una cosa que siempre me preocupa es que s\u00f3lo podemos sumar los valores cuando los criterios coinciden perfectamente con los valores. Digamos que tu nombre es John Martin. En este caso, si queremos agregar valores usando [&hellip;]","thumbnail_url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/donnees-pour-obtenir-les-totaux-de-la-facture-en-utilisant-sumif-avec-des-caracteres-generiques.png"}