This video explains how to use the *, ?, & and ~ syntax to create wildcard criteria for COUNTIFS and SUMIFS functions.
------------------------