how do you add up check boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to add up check boxes 2
Excel Move or Copy Stopped Working? 0
Check box = 1 2
How can I sum up several check boxes conditioned by a combo box? 4
Check Boxes Grouped 2
sum of check boxes that have been checked 2
Check Boxes 1
protect worksheet with check box 1

Back
Top