COUNTIF OR SUMIF Based on Partial Match, Wildcard Match, 'Contains', Fuzzy Match Using REGEX

[@IvanCortinas_ES]

Excellent tutorial. Thank you!!!

[@MaureenPesch]

Excellent- I use conditional columns for this, but my team doesn’t know power query. I’ll try this. Thank you!

[@hhasanat]

Thank you, Chester. But I did not find the function REGEXTEST. How to add it or create it