Sum of text Does not contain in Range

Sum of text Does not contain in Range
I hope you found a solution that worked for you :)
The Content is licensed under (https://meta.stackexchange.com/help/l...) CC BY-SA.
Attention! This video does always use the same license as the source!
Thanks to all those great people for their contributions!

(stackoverflow.com/users/25929407/srikanth)Srikanth
(stackoverflow.com/users/2872922/ron-rosenfeld)Ron Rosenfeld
(stackoverflow.com/users/8162520/mayukh-bhattacharya)Mayukh Bhattacharya
(stackoverflow.com/users/19547514/rotabor)rotabor
A special thanks goes out to the (stackoverflow.com/questions/79211030/sum-of-text-does-not-contain-in-range)Stackexchange community

I wish you all a wonderful day! Stay safe :)
If anything is off, please write me at peter D.O.T schneider A.T ois42.de

excel-formula excel