Help with SUMIFS combined with Xlookup using a wildcard

[shellwig]

Thank you in advance for your help.
I'm trying to return the value using wildcards for the text. I do not want to specify the range for each column, hopefully this can be done.
My formula is as follows: SUMIFS(XLOOKUP(F2&"*",B:B,D:D),A:A,G2,C:C,"*"&H2&"*")
See below snip of my excel sheet

 

[Fluff]

Why are you using xlookup? There is no need for it.

 

[shellwig]

Thank you for the help. I took out the xlookup from the formula and only used sumifs for all criteria.
I combined sumifs with an xlookup in a different model. I was trying to look across a range of columns which is why it worked vs 1 column with my value.
My solution: SUMIFS(D:D,A:A,@G:G,B:B,F2&"*",C:C,"*"&H2&"*")

 

[Fluff]

Glad you sorted it & thanks for the feedback.