COUNTIF CHECKBOXES FROM MULTIPLE SHEETS

Bobby1

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

Mike TV

@Bobby1

=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.

Bobby1

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)

Paul Newcome

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.