Newbie needs help on excel formula
Hello,
To count even numbers:
=SUMPRODUCT(--(MOD($B$3:$H$11,2)=0))
To count odd ones;
=SUMPRODUCT(--(MOD($B$3:$H$11,2)=1))
If both results do not add up to 63 then you have fractional numbers in
your area (1.1 or similar)...
HTH,
Bernd
|