Re: Countif function for Even and Odd numbers

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

I only responded to you because all you seem to do is belittle others in your
posts. Pointing out an error is one thing. But if an OP says they have a
column of odd and even numbers, and then gives an example of numbers, all of
which are whole numbers, and therefore, odd or even, then perhaps you can
expect that the OP actually knows what they are talking about. Perhaps you
should reconsider that instead of treating everyone like an idiot.
--
** John C **


"Harlan Grove" wrote:

John C <johnc@stateofdenial> wrote...
I guess the OP declaration of ...I would like to count a column that
consists of even and odd numbers ... means nothing then.

Not nothing, but little. Follow the newsgroups for a while and you'll
find that most OPs oversimplify their examples. If and when you gain
some experience responding in newsgroups, you may learn to anticipate
this.

Also, Google archives newsgroups, and some people (not many given the
frequency that the same questions get asked and answered) review the
archives for answers to commonly asked questions. While this OP may be
working only with integers, others who read this thread later could be
working with nonintegers.

Your argument, while technically correct, is unnecessary, as, per the OP,
the column will contain either even numbers or odd numbers.

Robustness is good. The formula

=SUMPRODUCT(--(MOD(A1:A10,2)>0))

is OBJECTIVELY LESS ROBUST than

=SUMPRODUCT(--(MOD(A1:A10,2)=1))

If robustness means little or nothing to you, pity for your employer
and co-workers.

.

Relevant Pages

  • Re: Countif function for Even and Odd numbers
    ... Follow the newsgroups for a while and you'll ... Also, Google archives newsgroups, and some people (not many given the ... the column will contain either even numbers or odd numbers. ... If robustness means little or nothing to you, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: AUEs Laura Spira
    ... > Looking at this rather odd comment again, ... > What are you responding to? ... The reality is that you can speak with authority only ...
    (alt.usage.english)
  • Re: Tuesday chat
    ... > This is odd. ... Looking at the time/date, it looks like you posted it ... > Tuesday, at 7:20pm, yet despite checking these newsgroups several times a ... Was definately fun. ...
    (comp.sys.atari.8bit)
  • Re: Intro...
    ... Thanks Sheldon for responding. ... How very odd! ... FTR, I just saw the original now. ... Moshe Schorr ...
    (soc.culture.jewish.moderated)
  • Re: Solution ?
    ... even numbers and 5 odd numbers from the user as input at the keyboard. ... for entering EVEN and ODD numbers in the array is 5. ... have an appropriate newsgroups line in your header for your mail to be seen, ... or the newsgroup name in square brackets in the subject line. ...
    (comp.lang.c.moderated)