Count Check Boxes across Sheets

[kknob]

Hi I'm trying to count check boxes across multiple sheets. I tried
= COUNTIF(Start:End!A2, "TRUE") but that didnt work, is there
another way of doing this? Thanks! I dont think it matters but I am
using Office 2003. Thanks again!

 

[T. Valko]

The easiest way to do this is to use another cell on each sheet.

I'm assuming that A2 is the check box linked cell. Enter this formula in B2:

=N(A2)

Then reference B2 in your other formula:

=SUM(Start:End!B2)

You tried with COUNTIF but the above SUM formula will do the same thing.

 

[kknob]

Thats what i was doing, just seeing if there was an easier way of
doing it, as in one formula on the master sheet. thanks!

 

[T. Valko]

just seeing if there was an easier way of doing it

That's about as easy as it'll get.

The only other way is to list the sheet names and use a much longer
complicated formula.