Closed Thread
Results 1 to 3 of 3

countif problem.

  1. #1
    psion
    Guest

    countif problem.

    I wrote a formula in a cell that contains the following:

    =countif(f5:f268,"> char(32)") / countif(e5:e268,"> char(32)")

    I have verified that any unused cells have blanks spaces in them.

    Both columns have data in the same rows so the counted value for each
    column should be the same but it isnt. All cells contain only numbers or
    letters and the cells format is general.

    Any suggestions??

  2. #2
    Bob Phillips
    Guest

    Re: countif problem.

    Not sure I get it, but try

    =countif(f5:f268,">"&char(32)) / countif(e5:e268,">"&char(32))

    "psion" <[email protected]> wrote in message
    news:[email protected]...
    >I wrote a formula in a cell that contains the following:
    >
    > =countif(f5:f268,"> char(32)") / countif(e5:e268,"> char(32)")
    >
    > I have verified that any unused cells have blanks spaces in them.
    >
    > Both columns have data in the same rows so the counted value for each
    > column should be the same but it isnt. All cells contain only numbers or
    > letters and the cells format is general.
    >
    > Any suggestions??




  3. #3
    psion
    Guest

    Re: countif problem.

    OK... Ive fixed the problem(but Im still unsure why it is happening).
    What I did to fix the problem is re-enter any cell that contain only
    numerical data. Alphanumeric was ok...

    Bob Phillips wrote:
    > Not sure I get it, but try
    >
    > =countif(f5:f268,">"&char(32)) / countif(e5:e268,">"&char(32))
    >
    > "psion" <[email protected]> wrote in message
    > news:[email protected]...
    >
    >>I wrote a formula in a cell that contains the following:
    >>
    >>=countif(f5:f268,"> char(32)") / countif(e5:e268,"> char(32)")
    >>
    >>I have verified that any unused cells have blanks spaces in them.
    >>
    >>Both columns have data in the same rows so the counted value for each
    >>column should be the same but it isnt. All cells contain only numbers or
    >>letters and the cells format is general.
    >>
    >>Any suggestions??

    >
    >
    >


Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1