Count cells that are numbers and odd

=SUMPRODUCT(--MOD(CellRange,2)=1))

Related Formulas

Count cells that are even numbers
Count cells that are positive
Count cells that are negative