Forum Discussion
I have a nine digit number for which the first three numbers determine what team this number belongs
I have a nine digit number for which the first three numbers determine what team this number belongs to. I hve over 800 numbers that begin with the numbers 101 throuhg 129. I have five teams that we ...
Hi Thomas McKissick,
Which function you want to do. You want to count them?
Use COUNTIFS function, if you want count of your team records.
For eg. If you want count of team '101', you have to put this formula.
=COUNTIFS(C:C,">=101000000",C:C,"<102000000")
Like this you should do for 5 teams. Give starting number and end number.