Counting Check Boxes Across Multiple Sheets

jcotten ✭✭
edited 12/09/19 in Formulas and Functions

I have the same sheet for 7 different individuals that has 12 columns and 38 rows...each cell is a check box.  I want to create the same sheet that shows a count of each sheet per cell.  So, how many of the 7 sheets selected row 1, column 2?  How many selected row 1, column 3?  And so on.

I have seen numerous discussions about how to count check boxes, which has been very informative, but I haven't seen any that count boxes across sheets.  I tried using COUNTIFS and the "Reference Another Sheet" option, but it got very convoluted very quickly.  I'm sure I'm doing something wrong by selecting multiple sheets...or maybe I'm not using the right components of the formula between each reference?  Any help would be much appreciated!!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!