LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Sum Only Checked Checkboxes

I want to create a column of checkboxes that connect with another column. I
want to sum only the checked boxes that connect with the data in the other
column.

Example:
Have "Total Amount" data in Column C. Want to create checkboxes in Column B.
Then want to add the checked boxes related to the specific data in Column C.

Cell Values C7 and C9 are checked in check boxes in B7 and B9. Cell Values
C8 and C10 are not checked in check boxes B8 and B10. How can I quickly add
only those checked boxes (B7 and B9) that relate to values in C7 and C9?

Many thanks in advance for any help.


 
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
Checkboxes vs. Option Buttons JW_4222 Excel Discussion (Misc queries) 2 February 1st 06 01:38 PM
How do I delete checkboxes from rows I deleted in a macro? Jazzi-D Excel Discussion (Misc queries) 1 January 18th 06 12:49 AM
My checkboxes will not stay checked. NUMBnut Excel Discussion (Misc queries) 0 January 9th 06 09:01 PM
Copy checkboxes to another sheet Trese Excel Discussion (Misc queries) 2 August 4th 05 01:17 PM
Counting the number of checkboxes on a spreadsheet Candice H. Excel Worksheet Functions 6 May 20th 05 05:27 PM


All times are GMT +1. The time now is 09:34 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"