Something like this, you could also put your date range into cells to make it easy to change (example in cell T3 below).
| S | T | U | V | W | X | AB | AC | AD |
1 | Start Date | 12/16/2017 | | | 3 | | | | |
2 | End Date | 12/20/2017 | | | 12/19/2017 | | | A | g |
3 | | 3 | | | 12/3/2017 | | | A | l |
4 | | | | | 12/18/2017 | | | A | A |
5 | | | | | 11/30/2017 | | | f | h |
6 | | | | | 12/11/2017 | | | A | A |
<colgroup><col style="width:30px; "><col style="width:87px;"><col style="width:87px;"><col style="width:46px;"><col style="width:34px;"><col style="width:76px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas |
Cell | Formula | W1 | =SUMPRODUCT(--(Data!W2:W53651>DATEVALUE("12/16/17")),--(Data!W2:W53651< DATEVALUE("12/20/17")),--((Data!AC2:AC53651="A")+(Data!AD2:AD53651="A"))) | T3 | =SUMPRODUCT(--(Data!W2:W53651>$T$1),--(Data!W2:W53651< $T$2),--((Data!AC2:AC53651="A")+(Data!AD2:AD53651="A"))) |
<tbody>
</tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4