+ Reply to Thread
Results 1 to 6 of 6

Countif not working

  1. #1
    Registered User
    Join Date
    05-27-2014
    MS-Off Ver
    2013
    Posts
    21

    Countif not working

    I'm trying to do a Countif on two data sets, both columns being numeric values, =COUNTIF($B$2:$B$1050,A2) and the results are all coming up as 0. I have done a =ISNUMBER check and they are all true for both columns, but my LEN count is showing that all cells (in both columns) contain 5 characters. This number should vary from 3 to 5 characters.
    I have copied and pasted values into a new sheet, formatted, tried pasting special and formatting to general to see if there were any issues but I can't find anything.

    Not sure if there is a formatting issue that I'm not picking up on or what the issue could be..

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Countif not working

    hello and welcome to the forum can you please upload a sample book.
    go to advanced tab---> select paper clip icon or go to manage attachment
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    05-27-2014
    MS-Off Ver
    2013
    Posts
    21

    Re: Countif not working

    Sample attached
    Attached Files Attached Files
    Last edited by birdie27; 05-27-2014 at 02:28 AM.

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Countif not working

    the formula is correct ! May be you don't have number present in the column B1:B1050 which you want to count from A1.
    You can check the same by changing any cell of B1:B1050 to the number present in A1 and you will get count as 1.

  5. #5
    Registered User
    Join Date
    05-27-2014
    MS-Off Ver
    2013
    Posts
    21

    Re: Countif not working

    It seems to be working now on the sample - after I retyped some of the data..perhaps I'm having a majorly blonde moment but I can't go through and retype all data (5000+ cells worth) - where am I going wrong with formatting?..

  6. #6
    Registered User
    Join Date
    05-27-2014
    MS-Off Ver
    2013
    Posts
    21

    Re: Countif not working

    Thanks hemesh!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif function not working at all on Mac
    By galaxytraveler42 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-08-2014, 05:31 PM
  2. [SOLVED] COUNTIF not working consistently
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2014, 11:09 AM
  3. Countif not working
    By raydaw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2008, 10:18 AM
  4. Countif, not working.
    By Clash in forum Excel General
    Replies: 2
    Last Post: 07-20-2006, 06:28 AM
  5. [SOLVED] countif not working
    By Nick Krill in forum Excel General
    Replies: 4
    Last Post: 06-24-2006, 02:45 PM

Tags for this Thread

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