use option button to define what range of cells to sum

[todaychris]

Hello I am trying to use an option button to select from a couple of different options. I am grouping car choice and then grouping transmission option. I am trying to allow someone to select an option and have it sum only the options selected and either gray out the other available options or clear the cell values from the other options. The scenario would be, once the option is selected a range of cells is summed and copied to a total at the bottom of the sheet. Last wondering how after the selection has been completed can clear the selected options and start over.

I am trying to use the ActiveX version of the option button but not sure how to set up.

Example

Option Button 1 (group a)
RED CAR
Black seats
Total $ 12000 cell (C5)

Option Button 2 (group a)
BLUE CAR
Black Seats
Total $ 12500 cell (H5)

Option Button 1 (group b)
Manual Transmission
Total $ 500 cell (L5)

Option Button 2 (group b)
Automatic Transmission
Total $ 950 cell (N5)


Total Price from both option groups $ xxxxxx cell ((Q5)

[protonLeah]

Attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[todaychris]

Test Option Button Selectable.xlsm

Hopefully the sheet was attached

[protonLeah]

"....I am trying to allow someone to select an option and have it sum only the options selected...."

On tab "2004" I placed
1. two Group Boxes, one for penta and one for wireless.
2. replaced ActiveX option buttons with five "forms control" option buttons in the penta group box, set the linked cell to I1. Select the five buttons and the group box then select "group".
3. replaced ActiveX option buttons for wireless with three forms control option buttons, and grouped them, etc.

For the total in E71:

=CHOOSE($I$1,0,E13,E21,E31,E44)+CHOOSE($J$1,0,E57,E65)

The penta option buttons will range from 1 - 5. Option button 1 will clear the other four and add zero to the sum, etc.

In F71, then:

=CHOOSE($I$1,0,F13,F21,F31,F44)+CHOOSE($J$1,0,F57,F65)

[todaychris]

Thanks protonLeah,

Exactly what I was wanting to perform. I now understand the form function a great deal more.

Thanks a bunch for the help.