Forum Discussion
How to count number of days a checkbox is checked.
Hello! I'm looking for a function that counts the total number of days (not just consecutive days) that a checkbox has been checked. For example, if I check the box for three days, uncheck it for some time, and then recheck it for another three days, I want a separate cell to spit out "6".
1 Reply
Hi aquaticdot,
You could use a simple Countif formula if you have not already tried that. Here is my example formula given that the column with the check marks is in column B and there is a checkmark in cell B1.
=COUNTIF(B1:B6, B1)
Simply select your range for the first condition, and then select a cell that has a checkmark in and press Enter. Let me know if this works for you.
