Combining Text Cell Reference with Wildcards in SUMIF

[T_H]

I’m trying to get this formula where in “E1” I can type what I’m searching for in the first column to then add up in the 2nd. Currently I’d need to type “*Text*” but would prefer to simply type “Text” How can I go about doing this?

=SUMIF($‘2022’.$B:$B,E1,$‘2022’.$C:$C)

Per the solution: =SUMIF($'2022'.$B:$B,CONCAT("*"&$E$1&"*"),$'2022'.$C:$C)

[3rdRockStephen]

Yay! Just what I’ve been looking for, tvm.
And in fact &$E$1&"*" works for me without CONCAT if I just want wildcard at end.

[erAck]

Replace the E1 reference with a "*"&E1&"*" concatenation.

[T_H]

Thanks, that worked for my use case.