Forum Discussion
MiguelCosta735
Oct 01, 2021Copper Contributor
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 ...
- Oct 01, 2021
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)
HansVogelaar
Oct 01, 2021MVP
Please attach a small sample workbook.
- MiguelCosta735Oct 01, 2021Copper Contributor
HansVogelaarHere is a sample workbook. I simply want to count the number of TRUE values for a specific date range. For this example, just for August.
- HansVogelaarOct 01, 2021MVP
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)
- MiguelCosta735Oct 01, 2021Copper Contributor
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)