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

Question

question

CicelyMason-0650 asked Feb 15, '21 emizhang-msft commented Feb 25, '21

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

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

office-excel-itpro

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft · Feb 16, 2021 at 09:35 AM

Hi,

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

0 ·

Answer 1 · 2021-02-15T17:16:58.857Z

Lz-3068 answered Feb 15, '21

Hi @CicelyMason-0650

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

demo.png (9.6 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question