How to count number of days a checkbox is checked.

%3CLINGO-SUB%20id%3D%22lingo-sub-3327001%22%20slang%3D%22en-US%22%3EHow%20to%20count%20number%20of%20days%20a%20checkbox%20is%20checked.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3327001%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I'm%20looking%20for%20a%20function%20that%20counts%20the%20total%20number%20of%20days%20(not%20just%20consecutive%20days)%20that%20a%20checkbox%20has%20been%20checked.%20For%20example%2C%20if%20I%20check%20the%20box%20for%20three%20days%2C%20uncheck%20it%20for%20some%20time%2C%20and%20then%20recheck%20it%20for%20another%20three%20days%2C%20I%20want%20a%20separate%20cell%20to%20spit%20out%20%226%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3327001%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3328857%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20count%20number%20of%20days%20a%20checkbox%20is%20checked.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3328857%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382238%22%20target%3D%22_blank%22%3E%40aquaticdot%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3EYou%20could%20use%20a%20simple%20Countif%20formula%20if%20you%20have%20not%20already%20tried%20that.%26nbsp%3BHere%20is%20my%20example%20formula%20given%20that%20the%20column%20with%20the%20check%20marks%20is%20in%20column%20B%20and%20there%20is%20a%20checkmark%20in%20cell%20B1.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSTRONG%3E%3DCOUNTIF(B1%3AB6%2C%20B1)%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESimply%20select%20your%20range%20for%20the%20first%20condition%2C%20and%20then%20select%20a%20cell%20that%20has%20a%20checkmark%20in%20and%20press%20Enter.%20Let%20me%20know%20if%20this%20works%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.