Excel Spreadsheets


Posted by Laurie Updegrove on August 20, 2001 6:10 AM

I put check boxes in my spreadsheet now how can I count them?



Posted by lenze on August 20, 2001 6:37 AM

Laurie: Each checkbox returns a TRUE/FALSE Value, which can be linked to a Cell Reference (Right Click Checkbox>Format). You can then use Countif or Sumif to tally the Trues(Checked) and False(unchecked)