Skip navigation

Totalling the number of check marks in my check list

712 Views 17 Replies Latest reply: Nov 21, 2011 2:52 PM by mistac RSS
1 2 Previous Next
mistac Calculating status...
Currently Being Moderated
Nov 20, 2011 5:38 PM

I know this question has been answered but the formula given did not work for me.  I have a checklist with column A being where my check marks are.  I would like to add the check marks from A2:A42.  the formula I used was

 

=COUNTIF(A2:A42, TRUE) and the answer I got was 0 which is not right, cause I at least have 28 check marks on that list.

 

Help!!!

  • fireflyer Level 2 Level 2 (310 points)
    Currently Being Moderated
    Nov 20, 2011 6:01 PM (in response to mistac)

    This seems to work:

     

    =COUNTIF(A2:A42,NOT(ISBLANK(FALSE)))

  • Wayne Contello Level 6 Level 6 (12,625 points)
    Currently Being Moderated
    Nov 20, 2011 6:19 PM (in response to mistac)

    =COUNTIF(A2:A42, "=TRUE")

     

    Screen shot 2011-11-20 at 8.19.04 PM.png

  • Jerrold Green1 Level 7 Level 7 (28,150 points)
    Currently Being Moderated
    Nov 20, 2011 6:44 PM (in response to mistac)

    Mistac,

     

    Your formula should have worked exactly as you wrote it. Try it in a fresh blank document and table. It's possible that there is something wrong in that document you are working on. When you select the cell with the formula, does the range A2:A42 get highlighted? This would indicate whether you are pointing the COUNTIF function at the proper place.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,150 points)
    Currently Being Moderated
    Nov 20, 2011 7:08 PM (in response to mistac)

    I know that these discussions can be confusing at first, so don't feel too bad. I must say though that it would be nice if you would say in your post which platform you are running Numbers on and to post in the proper discussion area for that platform. This is the OSX iWork area. There is a dedicated iOS iWork area as well, where the iOS version is discussed.

     

    Here is what column A looks like when the COUNTIF expression is not selected:

     

    Screen Shot 2011-11-20 at 10.02.48 PM.png

     

    This is what Column A looks like when the cell with the COUNTIF expression is selected:

     

    Screen Shot 2011-11-20 at 10.03.10 PM.png

     

    Notice that the range of cells in A is highlighted in blue background.

     

    When you select your COUNTIF expression, does your checkbox range turn blue?

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Nov 20, 2011 7:09 PM (in response to mistac)

    Hi mistac,

     

    Either of these works on my test table. The second uses all non-header, non-footer rows as the search range.

    The space before TRUE is optional. The formula works with or without it.

     

    =COUNTIF(A2:A42, TRUE)

    =COUNTIF($A, TRUE)

     

    You'll notice that the first is the same as your initial formula. Copied from your post and pasted into a cell in my table, your formula gave the same results.

     

    The only similar formula that gave me a zero result was =COUNT(A2:A42)

     

    Regards,

    Barry

  • Jerrold Green1 Level 7 Level 7 (28,150 points)
    Currently Being Moderated
    Nov 20, 2011 7:32 PM (in response to mistac)

    mistac wrote:

     

    Sorry Jerry,  I am new to all this.  This is the first time ever that I've used support.  The gets highlighted when I put it on the Macbook, but when I try and do the same thing on the Ipad it doesn't do it.

    Well, that's where I have a problem trying to help, since I don't have an iPad.

     

    Jerry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Nov 20, 2011 8:59 PM (in response to mistac)

    Hi mistac,

     

    I notice a set of quotation marks in the shot of the iPad:

     

    =COUNTIF("A2:A42",TRUE)

     

    Try removing them to leave:

     

    =COUNTIF(A2:A42,TRUE)

     

    In the formula box for the file transferred from the Mac, the blue triangle may be related to the cell range A2:A43, extending beyond the last checkbox (and, if I'm reading teh screen correctly, into a footer row).

     

    Try editing the range to A2:A42.

     

    Regards,

    Barry

1 2 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.