SUMIFS with text wildcard and multiple criteria in the same column

[rs1aj]

I use named ranges
My sum range is "HLn Total". My first Criteria_Range is "Month_Num" and the criteria is the current month. My second Criteria_Range is "Year" and the criteria is the current year. My thrid criteria_range is "Customer" and I want the criteria to be all customers that text starts with "Pra" and "Vec"

So, my formula looks like this:
=sumifs(HLn_Total,Month_Num,Month(today()),Year,year(today()),Customer,{"Pra"*,"Vec"*})

and of course this does not work. Please advice and thank you for your help.

[Jonmo1]

Close...

Try

=SUM(sumifs(HLn_Total,Month_Num,Month(today()),Year,year(today()),Customer,{"Pra*","Vec*"}))

[rs1aj]

I tried that but when I hit "Ctrl+Shift+Enter" at the end of the formula, a box pops up saying "Update Values........" and displays files that it wants me to choose. Same thing if I just try to hit "Enter"

[rs1aj]

One sec. Think I might see the problem. My Name Manager is looking to another file for "Month_Num".....

Let me change that

[Jonmo1]

No need for CTRL + SHIFT + ENTER

If it's prompting you to choose files to update values, then there's something wrong with one or more of your named ranges.

[rs1aj]

Worked perfectly. Thank you!!

[Jonmo1]

You're welcome.