Forum Discussion
Checkboxes not automatically updating using COUNTIF
Hey, all, I'm using the following function to set the checkbox boolean of a cell based on the amount of other cells checked: In cell A1: =IF(COUNTIF(A2:A3=2,TRUE),TRUE,FALSE) The formula works, bu...
Maybe I'm not seeing the bigger picture, but why not simplify the formula to be:
=AND(A2,A3)
I was assuming they want the IF and =2 for specific reasons but that really isn't the problem. The problem here is that online version of Excel is not behaving with respect to these checkboxes. Here are 2 checkboxes and 2 formulas looking them. In 1 is the simple formula and in the other I added a volatile function. Notice how after I clicked the 2 boxes the original still says FALSE but the other correctly updated to TRUE
again, this is happening on the online version NOT the desktop version