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.

--
Biff
Microsoft Excel MVP


"kknob" wrote in message
...
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!