Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

illegalprelude

macrumors 68000
Original poster
Mar 10, 2005
1,583
121
Los Angeles, California
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?
 
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:
Code:
=COUNTIF(A1:A100;TRUE)
A1:A100 can be checkboxes for example.
 
When I try that, I get "The Formula contains a syntax error"

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

6f5g08.png
 

Attachments

  • Example.numbers.zip
    63.3 KB · Views: 139
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.