Forum Discussion
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...
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
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
Awesome! Thanks. That adapted to what I needed. Appreciate the help.