COUNTIF CHECKBOXES FROM MULTIPLE SHEETS
I NEED A COUNTIF FORMULA FOR CHECK BOXES IN MULTIPLE SHEETS
=COUNTIF([Priority Vendor]:[Priority Vendor], 1) +COUNTIF([Priority Vendor]:[Priority Vendor], 1)
SHEET A SHEET B
Answers
-
=COUNTIFS([Priority Vendor]:[Priority Vendor], 1, {Priority Vendor Range 1}, 1)
You'll use a formula such as the one above. The [Priority Vendor]:[Priority Vendor] would count the range in the current sheet the formula is being placed into and the {Priority Vendor Range 1} would be a range you set up with a cross-sheet reference.
-
sorry let me clarify, i need to count check boxes from 2 separate sheets and return the total on my roll up sheet( sheet 3)
-
You would create two separate COUNTIFs and add them together exactly as you did in your original post. You would just need to create cross sheet references to the other sheets in place of the ranges.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!