Excel Magic Trick 374: COUNT Odd or Even Numbers

[@aceviewwood]

thank you so much. and with your inspiration, I note that I have to subtract the countif(range,0) and the countif(range,"") to make sure the blank is excluded. 😜

[@maryjoyzabala1710]

its been more than 10 years but this is still helpful, thank you!

[@excelisfun]

Glad this old video of mine still helps : ) And, yes, most of the old Excel tricks still work today : )

[@muhammadhamza7891]

may all ah bless u

[@RossMyher]

Instead of Countif, use another term in your Sumproduct that only gives 1 for non-zero values, like this: =SUMPRODUCT(--(MOD(B19:B26,2)=0),--(B19:B260))

[@healy178]

Thanks!!! Helped a lot!

[@exp3905]

Cool!

[@excelisfun]

Glad you liked it!

[@TheSpeedBridge]

How can I change the color of the odd and even numbers (Not the cell). When I type in a number on a spread sheet I want the odd numbers to be black and the even numbers red. Again, I don’t want to change the color of the cell just the number. I’m assuming this is easy but no one seems to show this. Thanks.