View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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.