Hi all.

.A......... B
10.....123 ab
20.....123ab
30.....ab 123
40.....ab123
50.....123
60.....ab

I need to sum values from column 'A' if same row in 'B' there's some digit.
So, in e.g. above the result would be 10+20+30+40+50=150

Thanks in advance.