+ Reply to Thread
Results 1 to 8 of 8

Countif Formula Stopped Working

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Polk County, Florida
    MS-Off Ver
    Excel 2007
    Posts
    3

    Countif Formula Stopped Working

    I have an attendance sheet for the children's program I am in charge of at Church. I created the countif formual to count how many children showed up on any given night and also how many times during the year that anyone particular child show up to the program. The formula I used was as follows:

    =countif(A4:A34, "X") for each night (at the bottom of each column) &
    =countif(A4:P4, "X") for the yearly count (at the end of each row)

    everything was working fine until I got to the second half of the year and I come to Column X, now my countif formula has stopped working, it no longer counts the "X" for attendance. Any thoughts. I have attached the attendance file for anyone who can help me.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Countif Formula Stopped Working

    There are no "X"s in column X in any of the spreadsheets.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Countif Formula Stopped Working

    Hi Jerry, and welcome to the forum.

    It's working OK for me - once you enter some Xs in column X, Y etc. of course!
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Countif Formula Stopped Working

    they both seem to be workink fine..there are no 'x',s for them to count, but as soon as I add 'x' into the column, the formulas adjust to the new count...unless I'm missing something?
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  5. #5
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Countif Formula Stopped Working

    All works here as well!
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  6. #6
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Countif Formula Stopped Working

    Are your calculation options on auto? or are they on manual?

  7. #7
    Registered User
    Join Date
    03-04-2013
    Location
    Polk County, Florida
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Countif Formula Stopped Working

    I dont understand, like I said it was working fine, until I tried to update my attendace files this morning, could I have inadvertinly turned something off, AutoCalc or something.

  8. #8
    Registered User
    Join Date
    03-04-2013
    Location
    Polk County, Florida
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Countif Formula Stopped Working

    AutoCalc was changed to manual, thank you all

+ Reply to 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