Can I use a wildcard in a SUMIF? Yes you can, and here is how you do it. <br />Also this will be the answer to how do you use Sumif with text criteria, and how do I do a wildcard criteria in Excel. Also this video will answer question to what is the like operator in Sumifs?, <br /><br />Query For Total Sales <br />=SUMIF(A5:A29,B2&"*",D5:D29) <br /><br />Query For Total Sales (handles blanks) <br />=IF(B2="",0,SUMIF(A5:A29,B2&"*",D5:D29)) <br /><br /><br />Can I use a wildcard in a Sumif?,How do you use Sumif with text criteria?,How do I do a wildcard criteria in Excel?,What is the like operator in Sumifs?, <br /><br />Check out my complete suite of Microsoft Excel Tips and Tricks. <br />https://www.youtube.com/@RabiGurungXybernetics/shorts <br />https://www.tiktok.com/@xybernetics247 <br />https://www.instagram.com/rabi.gurung247/ <br />https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/ <br />https://twitter.com/XyberneticsInc/media <br />https://www.reddit.com/r/Excel247/ <br />https://www.facebook.com/XyberneticsInc/reels/ <br /><br />#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks
