Countif Formula

Gary J

I am trying to count when a done box is checked on another companies Smatsheet Issues log.

I can achive this when I use my own sheets but am failing when using theirs.

This is the fx that I am using to referance the sheet below:

Paul Newcome

Your {Range} should just be the checkbox column and should not be repeated in the "criteria" section of the function.

=COUNTIFS({Range}, @cell = 1)