SUMIFS can use wildcard characters, but the wildcards only work on text-based codes.
Wildcard are the two symbols ? and *. They represent unknown characters.
The ? symbol represent a single unknown character.
The * symbol represents any number of unknown characters, including no unknown characters.
So ?A will find WA and SA but not TAS.
And ?A? will find TAS but not WA and SA.
And *A* will find WA, SA, TAS and ACT.
BUT these symbols do not work with numeric based codes.
In the image below you can see the results for the Dept and Account based codes.
The text-based Dept characters work, but the numeric Account codes don’t work with wildcards.
If you add a letter in front of the numeric code it works. See image below.