I have cells with part numbers, I.E.
123456-1
123456-2
24W65257-3
24W65257-4
24W24989-305
24W24989-306
852741-2007
852741-2008
456DFG8-709
456DFG8-710
etc.
I need formulas to find out how many odd numbered part numbers and how many even numbered part numbers I have total in a range of 100+ cells as these numbers equate to left and right sides of an aircraft?