I know that you can use * as a wildcard with sumif and countif
functions in excel worksheets, but I was wondering if it's also
possible in macros/vba.

For example:
Application.SumIf(Range(Cells(1, 32), Cells(433, 32)), "*.aa.1t",
Range(Cells(1, 17), Cells(433, 17)))

Is this possible? If not, alternatives to this would be greatly
appreciated.
Thanks,
Stefanie