Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel, how to count a list of check boxes some are checked? | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
Count Check Boxes | Excel Worksheet Functions | |||
count check boxes | Excel Worksheet Functions |