I have 10 sheets from the same template with True/False values.
I want to count the number of
True values in a certain cell across all sheets. I tried the following but it doesn’t work.
=COUNTIf(('1'!B3,'2'!B3,'3'!B3,'4'!B3, ..., '10'!B3),"=True")
I figured this works but is there any more convenient way?