Caixa De Seleção Excel

How to add Excel selection box / command values? 3

I have a template where I select different options in the comment / selection box. For each or the selected option, manually assign a value (R $) to the following cells. I will categorize / add these values ​​separately for each option or select. Example: Select option 1 three times, this is the value that is automatically assigned to these 3 cells manually.

update

Thank you dude, with Somas according to the voice signal, but it still lowers the suspicion.

In one of the columns, checkboxes or in all sales as a single option to train or follow the user to control the options.

My question is, how to keep the same formula as a combination box or criterion? In the case of the box, they only recognize the pea, or the talus of the cell.

= somase (standard interval [somase_interval])

Thanks!

LipiFer does not need to manually open attribution values ​​because it has a table of values.

To resolve your doubts, use or add:

= SUM (range_choices_specific_choice_range_values)

Caixa De Seleção Excel