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 in All of August ....column "DateApplied". Scratching my head on the formula...
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)
5 Replies
Sort By
Please attach a small sample workbook.
- MiguelCosta735Copper 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.
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)