Need formula to "sum number of duplicate occurance between two dates with one criteria ".
Thankyou for replying my post .Here i have Post the link for example.
https://docs.google.com/spreadsheets/d/1dPdLIsATDNIzuThgJVhqgdjZhbuAPc-TFnPOtyv_y-Q/edit?usp=sharing
C | D | |
2 | 1/1/2018 | 1 |
3 | 1/31/2018 | 0 |
4 | 3/2/2018 | 0 |
5 | 4/1/2018 | 0 |
6 | 5/1/2018 | 0 |
7 | 5/31/2018 | 1 |
8 | ||
9 | Criterion | 1 |
10 | Count | 2 |
{ =SUM(IF(D2:D7=D9,1,0)) }
A | B | |
1 | 1/1/18 | 1 |
2 | 1/31/18 | 0 |
3 | 3/2/18 | 0 |
4 | 4/1/18 | 1 |
5 | 5/1/18 | 0 |
6 | 5/31/18 | 0 |
7 | ||
8 | Start Date | 1/1/18 |
9 | End Date | 4/1/18 |
10 | Criterion | 1 |
11 | ||
12 | Count | 2 |
{ =SUMPRODUCT(IF(A1:A6>=B11,1,0),IF(A1:A6<=B12,1,0),IF(B1:B6=B8,1,0)) }
{=SUMPRODUCT(IF(Date>=StartDate,1,0),IF(Date<=EndDate,1,0),IF(CriterionColumn=Criterion,1,0)) }