In the past have been successful using the sumproduct to count based on multiple criteria. However, I can not get it to successful work with my date field that I am importing. Example of calculation below.
=SUMPRODUCT((AllStatusDetail!$E$4:$E$3205="Vanessa Rogers - CC&B")*(AllStatusDetail!$D$4:$D$3205="Y")*(AllStatusDetail!$F$4:$F$3205="9/15/2006 5:00:00 PM"))
=SUMPRODUCT((AllStatusDetail!$E$4:$E$3205="Vanessa Rogers - CC&B")*(AllStatusDetail!$D$4:$D$3205="Y")*(AllStatusDetail!$F$4:$F$3205="9/15/2006 5:00:00 PM"))