CountIf Date Range

[ryleepowell]

I struggle with CountIf functions. I know this should be pretty straight forward, but I can't wrap my mind around it.

Below is how the spreadsheet is set up. Don't worry about the conditional formatting of the cells or colors of the dates below. Just for visual. But I want each cell to auto update the tally whenever a new date is included in the range below.

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

<tbody>
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]April '16[/TD]
[TD="align: center"]May '16[/TD]
[TD="align: center"]June '16[/TD]

[TD="align: center"]3[/TD]
[TD="bgcolor: #F4C7C3, align: center"]3[/TD]
[TD="bgcolor: #F4C7C3, align: center"]16[/TD]
[TD="bgcolor: #B7E1CD, align: center"]20[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]July '16[/TD]
[TD="align: center"]August '16[/TD]
[TD="align: center"]September '16[/TD]

[TD="align: center"]5[/TD]
[TD="bgcolor: #F4C7C3, align: center"]3[/TD]
[TD="bgcolor: #F4C7C3, align: center"]12[/TD]
[TD="bgcolor: #F4C7C3, align: center"]8[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]October '16[/TD]
[TD="align: center"]November '16[/TD]
[TD="align: center"]December '16[/TD]

[TD="align: center"]7[/TD]
[TD="bgcolor: #B7E1CD, align: center"]21[/TD]
[TD="bgcolor: #F4C7C3, align: center"]15[/TD]

[TD="align: center"]8[/TD]
[TD="align: center"]January '17[/TD]
[TD="align: center"]February '17[/TD]
[TD="align: center"]March '17[/TD]

[TD="align: center"]9[/TD]

</tbody>

This is column F. Ideally I want to the range to be all of F. Like, CountIf anything in column F is between May 1 2016 and May 31 2016. I would put this formula in the cells below the dates to include that specific date range.


<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

<tbody>
[TD="align: center"]Meeting Set On[/TD]

[TD="bgcolor: #93C47D, align: right"]04/05/16[/TD]

[TD="bgcolor: #93C47D, align: right"]04/22/16[/TD]

[TD="bgcolor: #93C47D, align: right"]04/22/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/02/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/02/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/05/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/05/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/05/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/09/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/10/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/10/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/11/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/17/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/18/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/18/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/25/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/25/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/25/16[/TD]

[TD="bgcolor: #00FFFF, align: right"]05/26/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/02/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/02/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/06/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/07/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/08/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/08/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/08/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/09/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/09/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/09/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/09/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/14/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/14/16[/TD]

[TD="bgcolor: #FFD966, align: right"]05/25/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/15/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/16/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/21/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/21/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/29/16[/TD]

[TD="bgcolor: #FFD966, align: right"]06/29/16[/TD]

[TD="bgcolor: #A64D79, align: right"]07/01/16[/TD]

[TD="bgcolor: #A64D79, align: right"]07/07/16[/TD]

[TD="bgcolor: #A64D79, align: right"]07/26/16[/TD]

[TD="bgcolor: #8E7CC3, align: right"]08/11/16[/TD]

[TD="bgcolor: #8E7CC3, align: right"]08/11/16[/TD]

[TD="bgcolor: #8E7CC3, align: right"]08/16/16[/TD]

[TD="bgcolor: #8E7CC3, align: right"]08/19/16[/TD]

[TD="bgcolor: #8E7CC3, align: right"]08/22/16[/TD]

</tbody>

 

[oldbrewer]

=sumproduct(($a$1:$a$1000 >= T1)*($a$1:$a$1000 <= T2))

assumes T1= may 1 and T2 may 31

 

[oldbrewer]

[TABLE="width: 813"]
<colgroup><col><col><col><col><col span="5"></colgroup><tbody>[TR]
[TD][/TD]
[TD]01/04/2016[/TD]
[TD]01/05/2016[/TD]
[TD]01/06/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]01/07/2016[/TD]
[TD]01/08/2016[/TD]
[TD]01/09/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]01/10/2016[/TD]
[TD]01/11/2016[/TD]
[TD]01/12/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]01/01/2017[/TD]
[TD]01/02/2017[/TD]
[TD]01/03/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]01/04/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Meeting Set On[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/04/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/04/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25/04/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]24/05/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/06/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]B3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27/06/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]=SUMPRODUCT(($A$15:$A$43>=B1)*($A$15:$A$43< C1))[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14/07/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]31/07/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17/08/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/09/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD]D3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/09/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]=SUMPRODUCT(($A$15:$A$43>=D1)*($A$15:$A$43< B3))[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/11/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]09/11/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]10/11/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]27/11/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]14/12/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]31/12/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]17/01/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03/02/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]20/02/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]09/03/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]26/03/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]12/04/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]29/04/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]16/05/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02/06/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19/06/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06/07/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]23/07/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]