I have a nine digit number for which the first three numbers determine what team this number belongs

Yah, the logic is unclear. With bit another interpretation if, for example, for the Team1 are assigned numbers starting from 101, 105, 129 the total of numbers assigned to Team1 could be calculated as

=SUMPRODUCT((INT(A:A/1E6)={101,105,129})*1)