I get #N/A, don't you? Oddly, in XP I get #VALUE.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Epinn" wrote in message
...
=iseven(cell ref) or =isodd(cell ref) works fine. This is neat!

Has anyone tried to key in =iseven or =isodd (i.e. without the cell ref) in
a cell? I didn't get an error but ......

I'll let you find out. No idea what that means.

I use V 2003.

Epinn

"Oldersox" wrote in message
...
someone could provide a simpler solution but for the moment you can use the
'iseven' function (eg: =iseven(cell ref) This will reply true for an even
number and false for an odd number. You then just need to count the
responses. Two sumifs will do this for you. (note: you will need to have
the analysis toolpak add-in installed for the iseven function to work
(toolsadd-ins and then tick all add-ins except euros, you can tick euros if
you ever intend to work in european currencies))

"Bill.liu" wrote:

Hello,
Is there anybody can help me to count the odd or even in an excel area?
There is a data area which contains natural number.I need to count how
many
odd or even in this area.