Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using numbers and I have a column function at the footer row. I'd like it to produce a Countif() along with a word.

I tried: =Countif(Checkboxes,True) "Checkboxes" so that it would express for example 5 Checkboxes

That did not work as expected.

share|improve this question

You can do this in the custom cell format rather than the function.

  1. Go to the cell click format>manage custom cell formats
  2. From the Type pop-up menu, choose Number & Text
  3. Drag the (blue) Entered Text element from the Date & Time Elements box into the empty format field above the box.
  4. Place the insertion point after the element, and then type your text 'checkboxes'
  5. Click Ok to save.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.