=SUMIFS(AD2:AD1000, AF2:AF1000, "*123*")
The formula above is supposed to find all combinations of 123 in column AD and sums up the corresponding cells in column AF. By combinations of 123, I mean:
123
132
231
213
312
321
The code just returns the value "0" to me. What can be done? Take note...