Microsoft Excel Tips and Tricks
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
Credit Chester Tugwell