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)

[erAck]

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

[T_H]

Thanks, that worked for my use case.