Count cells with condition

I need to count the number of cells in Column D that contain a date (or is
not blank) AND Column C contains "Amanda" in the same row.

I had it (by trial and error) and cannot recreate.
Please help.

One way:

=SUMPRODUCT(--(D1:D1000<>""),--(C1:C1000="Amanda"))

In article <[email protected]>,
Amanda <[email protected]> wrote:

> I need to count the number of cells in Column D that contain a date (or is
> not blank) AND Column C contains "Amanda" in the same row.
>
> I had it (by trial and error) and cannot recreate.
> Please help.