Count Check Boxes across Sheets
 

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!

Count Check Boxes across Sheets
 

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!

Count Check Boxes across Sheets
 

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!

Count Check Boxes across Sheets
 

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.

--
Biff
Microsoft Excel MVP


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