One way:

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

In article ,
Amanda 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.