Forum Discussion

Bryan Dickey's avatar
Bryan Dickey
Copper Contributor
Apr 27, 2018
Solved

Formula Help - Checkbox triggers and sums

I am working on a sheet where I have users select a check box if a variable is true and then have that generate a number value in another cell that works as a score. The formula I am using to generat...
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Apr 27, 2018

    Hi Bryan,

     

    You have to generate something countable, so please replace this:

    =IF(D4,"0","")

    With this:

    =IF(D4,1,0)

     

    Or directly you can sum the range of TRUEs and FALSEs using this formula:

    =SUMPRODUCT(--(D4:D12))

     

    Regards

    Haytham

AAbdou's avatar
AAbdou
Copper Contributor
Oct 29, 2019

PhilHSEP 

 

You need to make sure to link the checkbox to a cell as well by filling the cell link field  when you right-click on the checkbox and click on Format Control.  You need to link the checkbox to a cell and this cell will have the result of checking/ un-checking the checkbox of TRUE/FALSE.

 

The formula I mentioned in the previous reply will help you count these TRUEs and FALSEs.

 

 

 

Abdelrahman Abdou,

Certified Microsoft Excel Expert, Consultant.

Founder, Owner @ ExcelBonanza.com

 

 

http://www.excelbonanza.com/ | 

https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/

PhilHSEP's avatar
PhilHSEP
Copper Contributor
Oct 29, 2019

AAbdou 

 

Here is the file I am working on. Each thermocouple (row) would have a series of two checkboxes in each cell. Each row would have two checkboxes. There would be 180 cells for each row filled with these checkboxes. They would totalize/sum and that number of uses would display in the red or blue cells for that row... Is there an easy way to do this without using much memory or computational space?

 

Any help greatly appreciated....Thanks very much for your help already..

 

Regards

Phil 

  • AAbdou's avatar
    AAbdou
    Copper Contributor
    Oct 29, 2019

    Hi PhilHSEP .

     

    You don't have your checkboxes connected to any cells, so you aren't going to be able to get any results from them.

    You need to connect them to cells using the steps I explained on my previous reply. Once you connect them to cells, these cells will have TRUE/FALSE values depending on the checkbox being checked/unchecked, and then you can do all kinds of calculations on them.

     

     

     

    Abdelrahman Abdou,

    Certified Microsoft Excel Expert, Consultant.

    Founder, Owner @ ExcelBonanza.com

     

     

    http://www.excelbonanza.com/ | 

    https://www.linkedin.com/in/abdelrahman-abdou-60240150 | https://www.youtube.com/channel/UC2-D2unZHustY_f6V7cj03Q | https://www.facebook.com/ExcelBonanza/

     

Resources