Using a checkbox to countif
I am trying to count based on 2 criteria if checkbox is checked. So far it only returns a zero value when the checkbox is checked. Here is what I have...
=COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, "true", {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review Total Loss Tes Range 3}, Client3)
Where tes range 1 is the checkbox and range 2 and 3 are the criteria. Any thoughts? What am I missing?
Comments
-
Checkbox values are 1 and 0. Try this:
=COUNTIFS({Real-Steel Estimator Review Total Loss Tes Range 1}, 1, {Real-Steel Estimator Review Total Loss Tes Range 2}, Appraiser5, {Real-Steel Estimator Review Total Loss Tes Range 3}, Client3)
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
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives