Count cells that are odd numbers

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


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