More than 1 countif criteria

K

KristyBT

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
R

Roger Govier

Hi

Try
=SUMPRODUCT(--($A$1:$A$1000=1032),--($B$1:$B$1000=date(2006,4,3)))
Change ranges to suit
 
Top