Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/SUMIF-COUNTIF-Contains-Text.xlsx

In this video I demonstrate how to perform partial match SUMIFS and COUNTIFS calculations using the wildcard characters * and ?

1) How to perform a contains text COUNTIFS or SUMIFS calculation with one or more criteria
2) How to perform a begins with or ends with text, COUNTIFS or SUMIFS calculation
3) How to specify the position of the character in your criteria, eg "/" must be the fourth from last character or "#" must be the second character.
------------------------