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")`

**Update**

I figured this works but is there any more convenient way?

`=sum(N('1'!B3),N('2'!B3),N('3'!B3),N('4'!B3))`