Can I use a wildcard in a SUMIF? Yes you can, and here is how you do it. 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?,
Query For Total Sales =SUMIF(A5:A29,B2&"*",D5:D29)
Query For Total Sales (handles blanks) =IF(B2="",0,SUMIF(A5:A29,B2&"*",D5:D29))
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?,
Check out my complete suite of Microsoft Excel Tips and Tricks. https://www.youtube.com/@RabiGurungXybernetics/shorts https://www.tiktok.com/@xybernetics247 https://www.instagram.com/rabi.gurung247/ https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/ https://twitter.com/XyberneticsInc/media https://www.reddit.com/r/Excel247/ https://www.facebook.com/XyberneticsInc/reels/
00:00Someone recently inquired, how do you calculate the total sales value if the user entered the first few character of the invoice ID like this on cell B2 and they want to display the total values in here.
00:11So this is how I do it, equal sum if, open parenthesis, the first argument on sum if will be the column for the invoice ID.
00:18And the second argument would be the criteria which the user entered on cell B2 and you're going to say ampersand double quote asterisk double quote.
00:26That takes care of any characters following the first three characters or however many characters that the user has entered.
00:32And the third argument will be the sales value column here, close parenthesis and hit enter and that's how you do calculation.
00:39But this formula is not entirely foolproof.
00:42What I mean by that, if you get rid of this, you can see it calculates the total values of the sale here.
00:47So the way to get around that would be to encapsulate an if statement on this one, equal to blank.
00:53You basically want to show a zero value, if it's not blank, you calculate the sum.
Be the first to comment