Hello peoples! First post here so, hello

My brain is failing on this formula situation today.

I have a URL list in Column B and values to add together in Column C
Columns L to Q have partial URLs in them, one row = one group of URLs

I'm trying to group the URLs by summing only if it contains ("*"&CELL&"*") certain text.

Example of the basic one:
=SUMIF($B$4:$B$53,"*"&L3&"*",$C$4:$C$53)
Which is fine. However! Some of the groups have up to 5 variations across their rows.
I have tried to add together the results of sumif formulas in one go, but it then drags in blank cells making the totals too high
=SUMIF($B$4:$B$53,"*"&L3&"*",$C$4:$C$53)+SUMIF($B$4:$B$53,"*"&M3&"*",$C$4:$C$53)
I have also tried Sumifs with multiple criteria, but it treats each criteria as an AND rather than an OR which causes rows with mutiple criteria to bring back 0.
=SUM(SUMIFS($C$4:$C$53,$B$4:$B$53,"*"&L3&"*",$B$4:$B$53,"*"&M3&"*",$B$4:$B$53,"*"&N3&"*",$B$4:$B$53,"*"&O3&"*",$B$4:$B$53,"*"&P3&"*",$B$4:$B$53,"*"&Q3&"*"))
I have also tried putting my criteria into an internal array, however this doesn't work as I'm looking for CONTAINS text rather than exact match.

=SUM(SUMIFS($C$4:$C$53,$B$4:$B$53,{"*"&L3&"*","*"&M3&"*","*"&N3&"*","*"&O3&"*","*"&P3&"*","*"&Q3&"*"}))
It's doing my nut in because I think it is doable, I just haven't found it yet.

Any and all help is much appreciated. Thanks!