How to count number of days a checkbox is checked.

[aquaticdot]

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".

[#2]

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.