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
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top