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>

	F	G	H
2	April '16	May '16	June '16
3	3	16	20
4	July '16	August '16	September '16
5	3	12	8
6	October '16	November '16	December '16
7	21	15
8	January '17	February '17	March '17
9

<tbody>
</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>

Meeting Set On

04/05/16

04/22/16

04/22/16

05/02/16

05/02/16

05/05/16

05/05/16

05/05/16

05/09/16

05/10/16

05/10/16

05/11/16

05/17/16

05/18/16

05/18/16

05/25/16

05/25/16

05/25/16

05/26/16

06/02/16

06/02/16

06/06/16

06/07/16

06/08/16

06/08/16

06/08/16

06/09/16

06/09/16

06/09/16

06/09/16

06/14/16

06/14/16

05/25/16

06/15/16

06/16/16

06/21/16

06/21/16

06/29/16

06/29/16

07/01/16

07/07/16

07/26/16

08/11/16

08/11/16

08/16/16

08/19/16

08/22/16

<tbody>
</tbody>

 

[oldbrewer]

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

assumes T1= may 1 and T2 may 31

 

[oldbrewer]

	01/04/2016	01/05/2016	01/06/2016
	3	1	2
	01/07/2016	01/08/2016	01/09/2016
	2	1	2
	01/10/2016	01/11/2016	01/12/2016
	0	4	2
	01/01/2017	01/02/2017	01/03/2017
	1	2	2
	01/04/2017
Meeting Set On
03/04/2016
20/04/2016
25/04/2016
24/05/2016
10/06/2016			B3
27/06/2016			=SUMPRODUCT(($A$15:$A$43>=B1)*($A$15:$A$43< C1))
14/07/2016
31/07/2016
17/08/2016
03/09/2016			D3
20/09/2016			=SUMPRODUCT(($A$15:$A$43>=D1)*($A$15:$A$43< B3))
07/11/2016
09/11/2016
10/11/2016
27/11/2016
14/12/2016
31/12/2016
17/01/2017
03/02/2017
20/02/2017
09/03/2017
26/03/2017
12/04/2017
29/04/2017
16/05/2017
02/06/2017
19/06/2017
06/07/2017
23/07/2017

<colgroup><col><col><col><col><col span="5"></colgroup><tbody>
</tbody>