Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.