SUMIFS & COUNTIFS Partial Match | Part of Cell Contains Text

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