+ Reply to Thread
Results 1 to 11 of 11

Countif not counting cells

  1. #1
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Countif not counting cells

    So I have ran into the most strange thing. When I input my data and do a countif on line 24 the first 3 cells count then the rest after that do not. No matter how I modify the data on the lines above it will not count. Anyone see something wrong?
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Countif not counting cells

    It works for me?

    T
    U
    V
    1
    Answered: B B
    2
    Answered: B B
    3
    Answered: A B
    4
    Answered: B B
    5
    Answered: B B
    6
    Answered: A B
    7
    Answered: B B
    8
    Answered: B B
    9
    Answered: B B
    10
    Answered: A B
    11
    Answered: B B
    12
    Answered: A B
    13
    Answered: B B
    14
    Answered: A B
    15
    Answered: A B
    16
    Answered: B A
    17
    Answered: A B
    18
    Answered: B A
    19
    Answered: No answer No answer
    20
    Answered: B B
    21
    Answered: A B
    22
    23
    a b
    24
    8
    18


    Do you have calcs set to manual. perhaps?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Countif not counting cells

    The first 3 rows work then after that NADA, Zip, Zilch.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Countif not counting cells

    You can see from my post above, that the count is working as it should.

    Is that really what your actual file looks like, or just dummy data?
    If that was dummy data, check your actual data for leading/trailing spaces, typos etc

  5. #5
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Countif not counting cells

    It is actual data. I have tried this on 2 different computers with 2 different versions of excel with the same results. Bizarre.

    Answered: B B A B D D B A C D C C B C A B D B A D D A B B D
    Answered: B B B C E B C D D D C C D A D B C C C C C C C C C
    Answered: A B No answer A D No answer No answer No answer No answer No answer No answer B C No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer
    Answered: B B A B D D B D C B B C D D B B A A D C D A B C D
    Answered: B B B A D B A D C No answer No answer C D No answer B D B No answer C A D B No answer C D
    Answered: A B A A E D C A C B D C D C B D A A C C D A C C B
    Answered: B B A B C C A A C B A C C No answer A C A A B C C D B C D
    Answered: B B A A E C A A C D D C D C B C B A B C D A D C D
    Answered: B B B A D C D C C C D C E D B A A B B C D D B B B
    Answered: A B B A C C D D C B B C E B B C A C A A C A C A C
    Answered: B B A A E A C B D B D C B No answer B No answer A No answer D No answer D No answer C No answer No answer
    Answered: A B B A E C A D C B D C E B B B C B B C C B B C B
    Answered: B B A A D No answer No answer D No answer No answer No answer No answer No answer No answer B No answer No answer No answer No answer No answer D D No answer No answer B
    Answered: A B B A E A D A C B D D B B A C C A B A D B C B B
    Answered: A B B A D C C C C B D B D B A B C B A B A D D B B
    Answered: B A B D D C D C C B D C No answer B C C B C C C D B A C B
    Answered: A B A C E No answer A B C No answer D B E No answer B B No answer No answer B D B B B A B
    Answered: B A B A B C D C C A D B D B A C C C B D B B C B C
    Answered: No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer
    Answered: B B B C C C D C C A D C C B A C B A B A A A A C B
    Answered: A B B A B C C No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer No answer

    a b a a e c c a d b c b d b a b b b c c d d c b d
    8 18 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

  6. #6
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Countif not counting cells

    I am so baffled. I have changed the formatting to general to text, copied and pasted to notepad and copied it back. Even if I try and change the grade manually it doesn't change the results. I have done this several times before with no problems, and now this....

  7. #7
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Countif not counting cells

    Hi,

    You have Trailing Space in ALL your Column Data From X1:AS21.

    Are these values manually entered, or imported...

  8. #8
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Countif not counting cells

    The data is radio clicked entered then exported to a file. There must be a programming error somewhere.

  9. #9
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Countif not counting cells

    Ok,

    Then until you correct the problem from the source of the data, you can use this for the meantime, in X24, copied to AS24:

    =COUNTIF(X1:X21,X23&"*")

  10. #10
    Registered User
    Join Date
    02-26-2013
    Location
    Ogden
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: Countif not counting cells

    I am getting a syntax error with that jtakw

  11. #11
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: Countif not counting cells

    I'm not, are you sure you entered the formula correctly, see attached.
    Attached Files Attached Files

+ 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. Replies: 8
    Last Post: 07-30-2018, 07:06 PM
  2. [SOLVED] COUNTA, SUMPRODUCT, COUNTIF, Counting blank cells.
    By BlindAlley in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-09-2017, 11:47 AM
  3. Counting the number of cells between two cells - NOT Countif
    By formexcel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-15-2016, 10:52 AM
  4. Countif - counting cells containing symbol in the excel row
    By karthikskengeri in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2013, 12:12 AM
  5. COUNTIF without counting blank cells
    By Melgaard in forum Excel General
    Replies: 5
    Last Post: 03-03-2010, 11:48 PM
  6. Errors in COUNT, COUNTA, COUNTIF when counting merged cells
    By Outback in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2006, 12:35 PM
  7. counting cells (COUNTIF) based on two or more criteria
    By Tricia S. in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-17-2005, 11:06 AM

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