=SUMPRODUCT(--(A2:A200=10032),--(B2:B200=--"2006-04-03"))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"KristyBT" wrote in message
...
I have the following data that I'm trying to do a countif on. What I need
is
to enter a formula that will count how many times 10032 was entered on
4/3/2006.

I have looked at other posts with more than 1 countif criteria but I
haven't
had any luck. Please help!

ColumnA ColumnB ColumnC
Vendor Date Salesman
10032 4/3/2006 DAMON
10032 4/3/2006 DAMON
10032 4/3/2006 DAMON
10032 4/3/2006 DAMON
10032 4/3/2006 DAMON
10032 4/3/2006 EVERETT
10032 4/3/2006 EVERETT
10032 4/3/2006 EVERETT
10032 4/3/2006 EVERETT
10032 4/3/2006 YVETTE
10032 4/3/2006 YVETTE
10032 4/3/2006 YVETTE
10032 4/3/2006 YVETTE
10032 4/3/2006 YVETTE
10032 4/3/2006 YVETTE
10032 4/3/2006 YVETTE
2619 4/3/2006 LYDIA
2619 4/3/2006 LYDIA
2619 4/3/2006 LYDIA
2619 4/3/2006 LYDIA
2619 4/3/2006 LYDIA
2619 4/3/2006 LYDIA
2619 4/3/2006 LYDIA