View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default 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