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
- Customer Resources
- 67.1K Get Help
- 448 Global Discussions
- 154 Industry Talk
- 504 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 80 Community Job Board
- 513 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!