Numbers: Text to have value

Discussion in 'OS X Mavericks (10.9)' started by illegalprelude, Dec 18, 2013.

  1. illegalprelude macrumors 68000

    illegalprelude

    Joined:
    Mar 10, 2005
    Location:
    Los Angeles, California
    #1
    Hey guys and gals,

    I'm putting together a spreadsheet in Numbers (latest build) for wedding invitations. Next to peoples name, I've created a pop-up menu with the option of Yes or No. Is there anyway for either this (or a checklist) that if they either select Yes or there is a checkmark that it can have a value (in my case of 1) so I can do a sum at the end?
     
  2. MatsSkoe macrumors member

    MatsSkoe

    Joined:
    Jul 28, 2013
    Location:
    Rotterdam
    #2
    You mean something like:
    Code:
    =COUNTIF(A1:A100;TRUE)
    A1:A100 can be checkboxes for example.
     
  3. illegalprelude thread starter macrumors 68000

    illegalprelude

    Joined:
    Mar 10, 2005
    Location:
    Los Angeles, California
    #3
    When I try that, I get "The Formula contains a syntax error"
     
  4. MatsSkoe macrumors member

    MatsSkoe

    Joined:
    Jul 28, 2013
    Location:
    Rotterdam
    #4
    I hope the attachment works. Try open it with Numbers.

    [​IMG]
     

    Attached Files:

Share This Page