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!!!
This seems to work:
=COUNTIF(A2:A42,NOT(ISBLANK(FALSE)))
I don't know what I'm doing wrong. That doesn't want to work either. Thanks for trying to help.
=COUNTIF(A2:A42, "=TRUE")
Ok this works on the Mac but not on the Ipad. What's the deal? I can't get it to work on the iPad. Sorry to be painful, and thank you for your help. It at least works on the Mac. 😀
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
The cell where I am trying to put my formula has a blue bold box around it. Does that mean it is highlighted? I have tried it on the Ipad in a different document. Still get zero has my total. grr. Sorry to be painful. Just want to use it right. The other option I have is to set it up on the Mac and transfer it across, but I won't always have the Mac with me. 😀 Again apologising for taking up your time.
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:
This is what Column A looks like when the cell with the COUNTIF expression is selected:
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
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
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.
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
Here is a photo of what I am doing on my iPad.
As you can see the formula is there but it's not adding up. There is only 1 check mark in column A.
Here is a picture of an imported document from the Mac to the iPad with the formula correctly inserted on the Mac. It comes up with a blue triangle on the iPad which does not appear on the Mac when looking at the same cell. I just would like to know how to do it correctly on the ipad. Skip the Mac.
Thanks for your help. At least I know how to do it on the Mac now. 😀 Very grateful to you for your time.
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
I have tried Barry. It doesn't let you. When I highlight to edit, the quotation marks don't actually come up. It only gives you A2:A43 and then when you're done, the quotation marks are there. It's really a bit painful! Everyone's suggestions have been great when working on the Mac. Numbers on the iPad is a little troublesome!! Thank you for suggestions and help though.
Might be time to repost ytour question in the iWork For iOS community. The link will take you there.
Regards,
Barry
Totalling the number of check marks in my check list
