Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you add up check boxes
I have check boxes on my Excel sheet. I can check and uncheck them. I would
like to be able to have a running total at the bottom. I want to be able to check somthing off in the collum and it show a total of checked boxes at the bottom. Can someone give me some help with this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you add up check boxes
Assuming you want to count how many are checked, if for instance you have 10
check boxes, link them to a range of cells somewhere off view like in AZ1:AZ10, then use a simple countif =COUNTIF(AZ1:AZ10,TRUE) will count how many are checked using default check values -- Regards, Peo Sjoblom Portland, Oregon "strider11580" wrote in message ... I have check boxes on my Excel sheet. I can check and uncheck them. I would like to be able to have a running total at the bottom. I want to be able to check somthing off in the collum and it show a total of checked boxes at the bottom. Can someone give me some help with this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering by Check Boxes | Excel Discussion (Misc queries) | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
check boxes - copy | Excel Discussion (Misc queries) | |||
Check boxes - when one box is checked, I want a 2nd box to auto ch | Excel Discussion (Misc queries) | |||
count check boxes | Excel Worksheet Functions |