Simple SUMIFS using multiple criteria for one range

[cappla011]

Hey all, this is probably a really simple question but I've been pulling my hair out and my Google-fu isn't apparently working. The SUMIFS formula in question is --

=SUMIFS($X:$X,$AH:$AH,"12"&"*",...other non-important criteria

Basically my issue is I want to sum everything in column X if column AH starts with 12 AND if it also starts with 13. I've tried

=SUMIFS($X:$X,$AH:$AH,AND("12"&"*","13"&"*"),...
=SUMIFS($X:$X,$AH:$AH,{"12"&"*","13"&"*"},...
=SUMIFS($X:$X,$AH:$AH,["12"&"*","13"&"*"],...

I also saw some things online about wrapping the whole formula in a =SUM but didn't fully understand.
I also know i could do =SUMIFS($X:$X,$AH:$AH,"12"&"*",... +SUMIFS($X:$X,$AH:$AH,"13"&"*",... but was hoping there was a way to do it only using the one SUMIFS formula?

Please let me know if you can help. Thanks!

 

[RoryA]

When you use an array of criteria, you get an array of results, which is why you need to wrap the whole thing in SUM() as well:

=SUM(SUMIFS($X:$X,$AH:$AH,{"12","13"}&"*"))

for example.

 

[cappla011]

Thank you so much! Yeah I think the {"12","13"}&"*" part was where I really stuck at. That makes sense though.

Appreciate the help.