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