Help to count a column where neither 'Complete' 'Canceled' checkboxes are selected
Hi all,
I am trying to build a formula that references another sheet, mostly focusing on 3 columns in that sheet:
At Risk (symbol)  Completed (checkbox)  Canceled (Checkbox)
I am trying to count all the values in the At Risk column where neither Completed or Canceled checkboxes are selected. Basically, I'm trying to count active projects that are at risk. I keep getting errors in every formula I try so I was wondering maybe someone could help get it working.
I thought I finally had it with this:
=IF(AND({Completed Checkbox}, 0, {Canceled checkbox}, 0), COUNTIF({At Risk}, "High"))
And then got a new error I hadn't gotten before #INVALID DATA TYPE
Can anyone help?
Best Answer

Try this formula:
=COUNTIFS({At Risk}, "Red", {Completed}, 0, {Canceled}, 0)
The logic is:
Count if all conditions are true (Range 1, Criterion 1, Range 2, Criterion 2, etc.)
I hope that helps!
Answers

Try this formula:
=COUNTIFS({At Risk}, "Red", {Completed}, 0, {Canceled}, 0)
The logic is:
Count if all conditions are true (Range 1, Criterion 1, Range 2, Criterion 2, etc.)
I hope that helps!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 199 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!