Numbers: Text to have value

[illegalprelude]

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?

 

[MatsSkoe]

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?

You mean something like:

=COUNTIF(A1:A100;TRUE)

A1:A100 can be checkboxes for example.

 

[illegalprelude]

You mean something like:

=COUNTIF(A1:A100;TRUE)

A1:A100 can be checkboxes for example.

When I try that, I get "The Formula contains a syntax error"

 

[MatsSkoe]

When I try that, I get "The Formula contains a syntax error"

I hope the attachment works. Try open it with Numbers.