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.
=SUMPRODUCT(--(MOD(A4:U29,2)=1),--(A4:U29<>""))
Any help would be awesome.