Count cells that are odd numbers

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

Related Formulas

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

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top