Count Check Boxes across Sheets

K

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

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.
 
K

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

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.
 
Top