Forum Discussion
Solved
How to count checkboxes between two dates
I want to count the number of checked boxes for an entire column that matches a certain date range. For example, I want to count the number of checked boxes under column "CriteriaA" that happen ...
Use
=COUNTIFS(A3:A12,">="&DATE(2021,8,1),A3:A12,"<="&DATE(2021,8,31),B3:B12,TRUE)
or
=SUMPRODUCT((MONTH(A3:A12)=8)*B3:B12)
Use
=COUNTIFS(A3:A12,">="&DATE(2021,8,1),A3:A12,"<="&DATE(2021,8,31),B3:B12,TRUE)
or
=SUMPRODUCT((MONTH(A3:A12)=8)*B3:B12)
HansVogelaarAmazing - that worked! One additional question, what if the column contents is YES / NO instead of True or False. Here's my code, however it won't work....shows 0 results.
=COUNTIFS(A3:A12,">="&DATE(2021,8,1),A3:A12,"<="&DATE(2021,8,31),B3:B12,YES)
YES is a text string, so you must enclose it in quotes:
=COUNTIFS(A3:A12,">="&DATE(2021,8,1),A3:A12,"<="&DATE(2021,8,31),B3:B12,"YES")