where TRIM part converts combination of two cells into array. When we compare first TRIM with min range, second one with max range, multiplication gives AND condition and SUMPRODUCT calculates how many numbers within the string are in the range. Finally return 1 if more than one or zero otherwise.
After that only to SUM all cells in columns C.
See details in attached file. Power Query variant is also here (second sheet).
Just tried it out and works perfectly. Thank you very much for the formula and speedy response. Have decided to gain a better understanding of excel and i guess the best place to start would be the Microsoft site with YouTube as a back up. Thank you again.
Microsoft support pages are better if to understand how this or that function works. For the patterns google helps to find them, I guess 99% of questions we have are already solved by someone, very often with explanations and variants of the solution. In a while you understand which resources are most suitable for you.