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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!