I'm using the following formula, but need to select groups whose names all
start with USA but end with different dept names, such as USA-Travel,
USA-Resort, USA-Hotel. There are approximately 10 dept's that start with
USA. Additionally, the sum should be for those dept's who have activity
during a particular month like Jan. Is there a way to include a wild card to
search/find all dept names that start with USA? I've tried using LEFT with 3
characters designated, but SUMPRODUCT doesn't seem to like it much.

=SUMPRODUCT(--($w$3:$w$200="USA-Travel"),--($U$3:$U$200="Jan"),($X$3:$X$200))