Hi,

for odd numbers:

=SUMPRODUCT((MOD($B$3:$H$11,2)=1)*1)

and for even numbers (including 0):

=SUMPRODUCT((MOD($B$3:$H$11,2)=0)*1)

Regards
Ingolf


abc99 schrieb:

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