Excel SUM based on Partial Text Match (SUMIFS with wildcards)

Save
2 years ago
12
excel sumifs excel sumifs with wildcard sumif function in excel excel sumifs partial match excel sum if sumif with two conditions SUM with contains criteria excel sum partial column excel sumifs contains excel sum conditional excel partial text match

‍‍‍‍November 29, 2018 Excel Advanced Formulas & Features
‍
‍Learn how to SUM values in Excel based on a partial text match. This is great for cases when you need to sum a column based on "criteria contains" a specific value or text.

For these cases you can use Excel's SUMIF or SUMIFS function together with wildcards. Examples of wildcards are the asterisk "*" sign or the Question mark "?".

The asterisk is a placeholder for zero or more characters. The ? mark is a fixed placeholder in terms of the numbers of characters. If you use the question mark once, this means only one character can be variable. If you use it two times, then two characters can be "anything". You can combine the question mark together with the asterisk sign as well. I show different examples on how you can do that in this video.

I also show you how you can sum based on two or more conditions. Here the SUMIFS formula comes in really handy.

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-sum-partial-text-match/

LINKS to related videos:
Absolute Relative referencing: https://youtu.be/FRu48zy-Djk
Excel SUMIFS Basics: https://youtu.be/AZuBNWMh7VM
SUMIFS between Dates: https://youtu.be/XIhbL20jTHc

★ My Online Excel Courses ► https://courses.xelplus.com/

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Loading comments...