Re: Checkboxes not automatically updating using COUNTIF

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