Finding Odd and Even Part Numbers

[Starbuk7]

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?

[pecoflyer]

Is the odd or even criteria based on the last digit?
If so = IF(mod(right(A1,2))=0,"even","odd") should help

[Starbuk7]

Odd or Even is based on the last number of the part number.

I would like a formula for Odd numbers to tell me how many Left Hand parts are in the range and a formula for Even numbers to tell me how many Right Hand parts are in the range if that makes sense?

In the example above there are 5 left hand and 5 right hand parts, but in my spreadsheet containing 100+ parts there is not an even number of each, this is why I need formulas to count quantities of even and odd part numbers.

[ConneXionLost]

Give these a try.

Even Numbered items:

Code: Select all

=SUMPRODUCT(--(MOD(RIGHT(A1:A10,1),2)=0))


Odd Numbered Items:

Code: Select all

=SUMPRODUCT(--(MOD(RIGHT(A1:A10,1),2)=1))


Cheers,

[Starbuk7]

That worked, Thank You!

[ConneXionLost]

Even simpler.

Even Numbered items:

Code: Select all

=SUMPRODUCT(--ISEVEN(RIGHT(A1:A10)))


Odd Numbered Items:

Code: Select all

=SUMPRODUCT(--ISODD(RIGHT(A1:A10)))


Cheers,