Not sure it worked for me.
Did you put the data in the same columns. I hide a number of columns in the example? As per your post the Dates are in columns F and AH.
What ver. of Excel do you have COUNTIF is in Excel 2007 and later.
See if SUMPRODUCT will work:
* | C | D | E | F | G | AG | AH | AI |
1 | * | * | * | Due | * | * | Sent | * |
2 | * | 3 | * | 11/5/13 | * | * | 11/5/13 | * |
3 | * | * | * | 10/20/13 | * | * | 10/22/13 | * |
4 | * | * | * | 10/22/13 | * | * | 11/1/13 | * |
5 | * | * | * | 11/4/13 | * | * | 11/3/13 | * |
6 | * | * | * | 11/8/13 | * | * | 11/9/13 | * |
7 | * | * | * | * | * | * | * | * |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:75px;"><col style="width:64px;"><col style="width:64px;"><col style="width:82px;"><col style="width:64px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas |
Cell | Formula | D2 | =SUMPRODUCT(--($F$2:$F$6<$AH$2:$AH$6)) |
<tbody>
</tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4