I have a long list of numbers that have five unique digits at the beginning of the number that signifies a specific product. What is the best way to sum up these products as I have indicated below? Your help is greatly appreciated. I'm using Excel 365.

12345678
12345876
01234565
01234575
23456780
23456874
23456235

12345 = 2
01234 = 2
23456 = 3

Thank you,
Karen