Re: Help with a COUNTIF (I think)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

No do not replace "--"

just copy the formula offered and paste it as it is...

=sumproduct(--isnumber(a2:a500))

IT WILL WORK.





"Marty" <Marty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0F83D184-2668-484F-A88E-F10B4AB859C5@xxxxxxxxxxxxxxxx
> Didn't work. Still yields a zero.
>
> I assume you intended me to replace the "--" with the A2:A500 range.
>
> Also, not sure why you're suggesting the use of SUMPRODUCT, since all I
> want
> to do is count the cells.
>
> What am I missing? Please say more.
>
> "N Harkawat" wrote:
>
>> =sumproduct(--isnumber(a2:a500))
>>
>> "Marty" <Marty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:BDE1BA51-C45A-435B-82FB-EF17B42245F6@xxxxxxxxxxxxxxxx
>> > Hello, all:
>> >
>> > I have a column of about 500 cells, some of which contain numbers, some
>> > contain blanks, and some contain the word "none". I want to put a
>> > formula
>> > in
>> > the cell at the top of the colum which counts ONLY those cells which
>> > contain
>> > numbers.
>> >
>> > Is there a specific function which will recognize only numbers?
>> > Failing
>> > that, I assume a COUNTIF is in order.
>> >
>> > I tried this:
>> >
>> > =COUNTIF(A2:A500,AND("<>""","<>none"))
>> >
>> > but it yields a zero. I've also tried variations moving around and
>> > eliminating the double quotes but I can't get it to work.
>> >
>> > Any suggestions? Help is appreciated. Thanks,
>> > MARTY
>>
>>
>>


.

Relevant Pages

  • Re: Issue with zero/# issue!!
    ... cells and adjusted the formula. ... I had "" (double quotes) in the FALSE ... argument instead of just putting 0 (number zero). ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with a COUNTIF (I think)
    ... Still yields a zero. ... Also, not sure why you're suggesting the use of SUMPRODUCT, since all I want ... to do is count the cells. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Complex if
    ... all of the conditions are either empty, have text, or have the numerical value zero. ... it suggests that those cells that meet the conditions contain zero -- assuming that #2 and #3 return exactly zero. ... IF('Enroll I'!$K$2:$K$2921>0, Enroll I'!$L$2:$L$2921))))))) ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Find same value in continuous Cells
    ... I double checked my cells. ... The first zero value in this sheet occurs at E81 ... Dim Lastrow As Integer 'Last Row of Printing Range ...
    (microsoft.public.excel.programming)
  • RE: carry down total
    ... Now how do I get it not to reset to total to zero but be able to carry it to ... cruchnin numbers ... "Joel" wrote: ... tow cells inside the ANDare cells that contain the TRUE ...
    (microsoft.public.excel.misc)