Results 1 to 4 of 4

Thread: CountIf Error

  1. #1
    Neophyte grt2bsec's Avatar
    Join Date
    Jan 2019
    Location
    Asheville, NC USA
    Posts
    2
    Articles
    0
    Excel Version
    Office 365

    Question CountIf Error



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello and thank you in advance for any assistance you may have to offer. I've removed some proprietary information but have left the formula cells on the attached. The purpose of the sheet is to determine if the column D Coil_Num has appeared anywhere in the prior weeks lists of columns E through N. The CointIf function seemed to be accomplishing that, but I noticed the yellow highlighted cell is incorrect. I'm not sure if there are other inconsistencies but noted this one. The formula should have returned 1 for 1 prior instance.
    Attached Files Attached Files

  2. #2
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    65
    Articles
    0
    Excel Version
    2013
    If you are referring to M20, the value in that cell is 2326386 whereas the value in D10 is 2326386.001
    Hence you get a count of 0

  3. #3
    Neophyte grt2bsec's Avatar
    Join Date
    Jan 2019
    Location
    Asheville, NC USA
    Posts
    2
    Articles
    0
    Excel Version
    Office 365

    Thanks!

    Quote Originally Posted by Fluff View Post
    If you are referring to M20, the value in that cell is 2326386 whereas the value in D10 is 2326386.001
    Hence you get a count of 0
    Wow, I didn't consider that Thanks!

  4. #4
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    65
    Articles
    0
    Excel Version
    2013
    You're welcome & thanks for the feedback

Posting Permissions

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