 | |
| Excel SUM based on Partial Text Match (SUMIFS with wildcards) |
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.
Related Topics:
Post a Comment