View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abc99 abc99 is offline
external usenet poster
 
Posts: 1
Default Newbie needs help on excel formula


Hi, i have a problem if i need to count the number of occurrences of odd
or even numbers in an array how should i go about writing it. COUNTIF
and COUNT does not seem to work. Haveing some difficulties in writing
the formula.

I.e from B3:H11 i need to count the number of times odd and even
numbers occurs; how should i write the formula or what formula should i
use. Please advice. Thank you. ^^


--
abc99
------------------------------------------------------------------------
abc99's Profile: http://www.excelforum.com/member.php...o&userid=35992
View this thread: http://www.excelforum.com/showthread...hreadid=557805