Forum Discussion
Solved
Excel Online Checkbox COUNTIF Issue – Checkbox State Resets Unexpectedly
Hi everyone, I'm experiencing an issue with checkboxes in Excel Online. I have a table where I use checkboxes (TRUE/FALSE) in five rows, and below them, I use the following formula to count how many...
I've noticed a problem, too. An easy workaround is to type 'false' or 'true' rather than checking the box. It's a good idea to send feedback about this so Microsoft hears about it.
Some other people shared similar problem. Looks like a bug in Excel for web. Workaround, as Kidd_Ip suggested, to use any suitable volatile function. That could be OFFSET. That could be
=COUNTIFS(F1:F5, TODAY()=TODAY() ), whatever, depends on situation.