SumIf / SumIfs with multiple Contains Text criteria

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:

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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!

So simple and yet so effective, I think I was trying to make things too complicated for myself.

Thankyou!