Forum Discussion

MiguelCosta735's avatar
MiguelCosta735
Copper Contributor
Oct 01, 2021
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 ...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Oct 01, 2021

    MiguelCosta735 

    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)

MiguelCosta735's avatar
MiguelCosta735
Copper Contributor
Oct 01, 2021

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.

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 01, 2021

    MiguelCosta735 

    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)

    • MiguelCosta735's avatar
      MiguelCosta735
      Copper Contributor
      Oct 01, 2021

      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)

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Oct 01, 2021

        MiguelCosta735 

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

Resources