=SUMPRODUCT(--( B2:B22 = "associate"),--(C2:C22<""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Nicole Bradshaw" <Nicole wrote in
message ...
Hi, I'm trying to prepare a summary worksheet to count where
B2:B22 = "associate"
and
C2:C22 contains a date (or is not blank)

I'm sure it's doable but I'm stumped. Thanks.

Nicole