Eraserhead macrumors G4 Original poster Nov 3, 2005 10,434 12,250 UK Oct 2, 2007 #1 If I have a table in Numbers, which contains checkboxes is it possible to count how many are checked? Thanks
If I have a table in Numbers, which contains checkboxes is it possible to count how many are checked? Thanks
iSaint macrumors 603 May 26, 2004 5,225 2 South Mississippi y'all, near the water! Oct 2, 2007 #2 There should be a 'count' or 'countif' function. I don't have Numbers, so I'm taking a stab.
Eraserhead macrumors G4 Original poster Nov 3, 2005 10,434 12,250 UK Oct 2, 2007 #3 iSaint said: There should be a 'count' or 'countif' function. I don't have Numbers, so I'm taking a stab. Click to expand... It doesn't seem to work . I've attached the spreadsheet in case someone else can help. Attachments Year 3 Stuff.zip 96.3 KB · Views: 266
iSaint said: There should be a 'count' or 'countif' function. I don't have Numbers, so I'm taking a stab. Click to expand... It doesn't seem to work . I've attached the spreadsheet in case someone else can help.
wordmunger macrumors 603 Sep 3, 2003 5,124 3 North Carolina Oct 2, 2007 #4 Here's your syntax: =COUNTIF(Term 1,"true")
Eraserhead macrumors G4 Original poster Nov 3, 2005 10,434 12,250 UK Oct 2, 2007 #5 wordmunger said: Here's your syntax: =COUNTIF(Term 1,"true") Click to expand... Thanks