Thanks for pointing that out...

"Peo Sjoblom" wrote:

No need to enter with ctrl + shift & enter

--


Regards,


Peo Sjoblom

"Sheeloo" wrote in message
...
You can use =sumproduct(--(b2:b22="associate"),--(c2:c22="your date
condition"),--(c2:c22<""))

Enter this with CTRL-SHIFT-ENTER

I am not sure how to test a cell for a date...

"Nicole Bradshaw" wrote:

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