Re: Countif function for Even and Odd numbers

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You did not cause an uproar and there is no need to apologize!

This forum is here to provide peer to peer help. It seems that you got more
help than you probably expected but the bottom line is that your question
was answered and it was answered correctly. The thing to understand about
Excel is that there are almost always *many* different ways to do something
and if you get exposed to more than one of those ways then you're able to
evaluate each and choose which is best for your application.

Please don't hesitate to ask questions in the future.

--
Biff
Microsoft Excel MVP


"Jezzy" <Jezzy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DDD5779E-4577-4ECB-B660-0B31A8188E28@xxxxxxxxxxxxxxxx
Hi All,

I am sorry if I cause an uproar here. It's my first time in this forum.
I
also have very basic knowledge of Excel. I am self-employed and trying to
get myself familiar with the program. Maybe in future if I come across
any
difficulties I will provide more details and proper questions. My
apology.
I do appreciate the generous help given by all you people.

"Jezzy" wrote:

Hi Hi,

I need help with a formula. I would like to count a column that consists
of
even and odd numbers eg. 28, 31, 43, 50, 60. I like to count how many
numbers in that column is odd or even.

I have tried the following but it didn't work

=countif(a1:a10,"1","3","5")

Appreciate some help here.

Thanks



.

Relevant Pages

  • Az - my conduct at RSB...
    ... using rec.groups and I can longer see posts from you know who.. ... interaction wth you know who upset anybody, I thought it was funny, and ... I really apologize for that. ... Hopefully the forum ...
    (rec.sport.billiard)
  • Yahoo Mail -- Drop Downs Not Responding
    ... I apologize if this isn't the right forum, but not sure where else to post. ... I've been using Yahoo! ... I do have a Google toolbar, I suspose that could be updated unbeknownst to ...
    (microsoft.public.windowsxp.help_and_support)
  • Turn off index "idenifiers?"
    ... I apologize if this is in the wrong forum. ... to display the screen so that the reader doesn't see the index data as ... Once a payment is received from the insurance ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Hes BAA-AACK (Not Really)
    ... that I am reluctantly withdrawing from this forum. ... had time to read from it for the past few days, so I apologize for not ... replication better. ...
    (talk.origins)