Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
strider11580
 
Posts: n/a
Default 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   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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering by Check Boxes Eggtavius Excel Discussion (Misc queries) 2 January 18th 06 04:41 AM
Can you sort with check boxes? Q Excel Discussion (Misc queries) 3 November 10th 05 08:11 PM
check boxes - copy MarkT Excel Discussion (Misc queries) 2 October 20th 05 04:33 PM
Check boxes - when one box is checked, I want a 2nd box to auto ch Russell-stanely Excel Discussion (Misc queries) 2 July 1st 05 08:52 PM
count check boxes Tony Excel Worksheet Functions 3 April 8th 05 03:48 AM


All times are GMT +1. The time now is 10:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"