Assign a numeric value to a Cell with a Checkbox or if selected in Excel

Question

Assign a numeric value to a Cell with a Checkbox or if selected in Excel

Cicely Mason 21

Hi,

I have five columns each with different values. I want to add a checkbox so that when they click on that cell, it assigns that value from the criteria column in the cell. Then I want to be able to add those totals going across. See below for example

                                 Criteria1    Criteria2     Criteria3    Criteria4     Criteria5      Total 
                                     w=20        w=15         w=5           w=15        w=10

Project A x x x 35
Project B x x x 40
Project C x 15

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-02-16T09:35:08.857+00:00

Hi,

Thanks for accepting answer here. Other partners who read the forums with the same issue can get more information from the correct result.

Accepted answer

0 additional answers

Your answer

Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff

2021-02-16T09:35:08.857+00:00

Hi,

Thanks for accepting answer here. Other partners who read the forums with the same issue can get more information from the correct result.

Answer 1

Lz._ 9,016

Hi @Cicely Mason

Doable with checkboxes but that's crazy to put in place (avail. here for download). Instead:

In G3 (and copy down) : =SUM(IF(B3:F3<>"",B$2:F$2,)) and validate with Ctrl+Shift+Enter if you don't run Excel 365 + Hide row 2

Share via

Assign a numeric value to a Cell with a Checkbox or if selected in Excel

0 additional answers

Your answer