Count totals in an entire colummn with Checkboxed value
I have a file with a column containing values with the Orange color selected in the checkbox showing as below. I want to get the total counts to count the Orange colored ones only (e.g.4 out 6). The formula I tried to use is: =Countif({boxcolum name}:{boxcolum name},1) or =Count({boxcolum name}:{boxcolum name} but only got returned invalid values from either formula.
Can anyone help?
Thanks,
Linda
Answers

Are you trying to do this on the sheet summary? If so, square brackets around your column name should fix the problem. The formula below should work once you replace Column Name with the name of your column.
=COUNTIF([Column Name]:[Column Name], 1)
Cheers,
John

Hi John,
I used COUNTIF same as your formula above by referencing another sheet as: =Countif({boxcolum name}:{boxcolum name},1) but got an error result.
Yes,the formula =COUNTIF([Column Name]:[Column Name], 1) worked with the Sheet Summary but it needs to take some extra steps to link the value from the Sheet Summary into another sheet, which I really try to avoid.
I just want to figure out how the checkbox formula works by referencing another sheet. Any idears?
Thanks,
Linda
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!