Return ODD/EVEN count after a certain number

[JRM333]

I am looking for a way to return a count of odd numbers after the number 24. It is being used for trials in an experiment and the first 24 are not counted (I am not setting up the experiment - just the tech guy). I want to return the number of odds after 24 and the number of evens after 24. I have used the formula below for the odds, but I cannot find anything to start the count after 24. I was thinking of an IF statement but cannot get it to work.

=SUMPRODUCT(--(MOD(A4:U29,2)=1),--(A4:U29<>""))

Any help would be awesome.

 

[Rick Rothstein]

Maybe this...

=MAX(0,SUMPRODUCT(--(MOD(A4:U29,2)=1))-24)

 

[JRM333]

Seemed like it worked for the odds, but not the evens

ODDS:
=SUMPRODUCT(--(MOD(A4:U29,2)=1),--(A4:U29<>""))

EVENS:
=SUMPRODUCT(--(MOD(A4:U29,2)=0),--(A4:U29<>""))

 

[Rick Rothstein]

Seemed like it worked for the odds, but not the evens

ODDS:
=SUMPRODUCT(--(MOD(A4:U29,2)=1),--(A4:U29<>""))

EVENS:
=SUMPRODUCT(--(MOD(A4:U29,2)=0),--(A4:U29<>""))

Sorry, I forgot about the EVENs...

=MAX(0,SUMPRODUCT(--(MOD(A4:U29,2)=0),--(A4:U29<>""))-24)

 

[JRM333]

Thank you. I will send it along and see if it works.